| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Try...
=SUMPRODUCT(--(H2:Z2="PM"),--(H3:Z3="h")) If you plan to enter the formula in A3 and copy it down the column, try the following instead... =SUMPRODUCT(--($H$2:$Z$2="PM"),--(H3:Z3="h")) Hope this helps! In article , "JanetP3810" wrote: 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 | |||
| Count how many different text values in an array. | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
| Count number of Unique values | Excel Worksheet Functions | |||
| How do I count my data that are between specific values? | Excel Worksheet Functions | |||
Hybrid Mode
