How do I count data that meets more than one criteria?

  • Thread starter Thread starter numbatwombat
  • Start date Start date
N

numbatwombat

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.
 
=SUMPRODUCT(--(B2:B100="Commercial"),--(C2:C100="Current"))

If this post helps click Yes
 
Back
Top