Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
need formula to count cells below | Excel Discussion (Misc queries) |