=SUMPRODUCT((H2:Z2="PM")*(H3:Z3="h"))
--
Vasant
"JanetP" wrote in message
...
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.
|