Need formula to count specific cells in a row

[Guest]

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.

 

[Vasant Nanavati]

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

 

[JulieD]

Hi Janet

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

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for details on this function