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

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.
 
J

Jacob Skaria

=SUMPRODUCT(--(B2:B100="Commercial"),--(C2:C100="Current"))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count values w/ criteria located in more than one column 3
How do I count data in range A:A that is dependent upon criteria . 1

Top