| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count the number of cells that meet multiple criteria?
I want to count cells from 3 worksheets that meet multiple criteria.
I've tried with a result of 0 (it should be 3): =SUMPRODUCT((Mark!X9:X258=Info!B15)*(Mark!F9:F258= Mark!Y9)*(Mark!F9:F258=Mark!Y10)*(Craig!X9:X258=In fo!B15)*(Craig!F9:F258=Craig!Y9)*(Craig!F9:F258=Cr aig!Y10)*(Dan!X9:X258=Info!B15)*(Dan!F9:F258=Dan!Y 9)*(Dan!F9:F258=Dan!Y10) I've also tried with a result of 0: =SUMPRODUCT(--(Mark!X9:X258=Info!B15),--(Mark!F9:F258=Mark!Y9),--(Mark!F9:F258=Mark!Y10),--(Craig!X9:X258=Info!B15),--(Craig!F9:F258=Craig!Y9),--(Craig!F9:F258=Craig!Y10),--(Dan!X9:X258=Info!B15),--(Dan!F9:F258=Dan!Y9),--(Dan!F9:F258=Dan!Y10) Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells that meet 2 criteria | Excel Worksheet Functions | |||
| Count the number of values in a list that meet certain criteria | Excel Worksheet Functions | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
| How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions | |||
Threaded Mode
