| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count data that meets more than one criteria?
I would like to use a formula to count the number of lines in a table that
meet multiple criteria, for example in the following simplified table I would like to count each of the Sector and Status combinations (entries that are commercial and current, commercial and declined etc). Description Sector Status Office1 Commercial Current Shop1 Retail Declined Office2 Commercial Declined Office3 Commercial Declined Bridge Civil Awaiting decision Shed Industrial Current Any suggestions would be much appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count data that meets more than one criteria?
=SUMPRODUCT(--(B2:B100="Commercial"),--(C2:C100="Current"))
If this post helps click Yes --------------- Jacob Skaria "numbatwombat" wrote: I would like to use a formula to count the number of lines in a table that meet multiple criteria, for example in the following simplified table I would like to count each of the Sector and Status combinations (entries that are commercial and current, commercial and declined etc). Description Sector Status Office1 Commercial Current Shop1 Retail Declined Office2 Commercial Declined Office3 Commercial Declined Bridge Civil Awaiting decision Shed Industrial Current Any suggestions would be much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count entries that equal one criteria if another column meets anot | Excel Worksheet Functions | |||
| Need to report a count that meets multiple criteria. | Excel Worksheet Functions | |||
| SUM data if meets criteria | Charts and Charting in Excel | |||
| How do I count in column A when it meets all criteria in three col | Excel Worksheet Functions | |||
| how can i count a number that meets a criteria? | Excel Worksheet Functions | |||
Linear Mode
