Trying to count specific values

J

JanetP3810

In row 2 I have some columns that contain AM and some that contain PM. In
row 3 I have either "h" or "e" or "u". In a3 I would like to have a formula
which would tell me how many h's are in any cell in row 3 between column h
and column z that has a PM in row 2.
 
D

Domenic

Try...

=SUMPRODUCT(--(H2:Z2="PM"),--(H3:Z3="h"))

If you plan to enter the formula in A3 and copy it down the column, try
the following instead...

=SUMPRODUCT(--($H$2:$Z$2="PM"),--(H3:Z3="h"))

Hope this helps!
 
Top