Am looking for help on active cell. Need something to look at the curent cell and count
based on the value of that cell (If cell.value = 2 then count = 1) this would be done on several worksheets with the same macro. The count for all the sheets would go into one cell something like

if ActiveCell.Value = 2, 3 or 4 Then Count
Range("AQ38").Value = Count

Any help would be wonderful!