| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count with Multiple criteria
Range D2:D10 contains the years 2003 and 2004. In C4:C10 there is a
payment status "Paid" or "Oustanding". I want to count the instances in C4:C10 where it indicates "Outstanding" where 2003 is indicated in D4:D10" Thanks for your assistance DK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count with Multiple criteria
DK
=SUMPRODUCT((C2:C10="outstanding")*(D2:D10=2003)) The number of rows needs to be the same. Regards Trevor "Dk" wrote in message oups.com... Range D2:D10 contains the years 2003 and 2004. In C4:C10 there is a payment status "Paid" or "Oustanding". I want to count the instances in C4:C10 where it indicates "Outstanding" where 2003 is indicated in D4:D10" Thanks for your assistance DK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count with multiple criteria in multiple cells | Excel Worksheet Functions | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Linear Mode
