View Single Post
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

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