Need formula to count specific cells in a row
 

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.

=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.

Hi Janet

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

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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.