Count based on two different criteria

D

dabnat

Sheet name Active
column C has names of counties example: marion
column H has the way something sold example: estate sale

I need a count where column C1-C10000 = marion AND H1 - H10000 = estate sale

How do you create a formula based on 2 requirements that have to be true to
be counted?
 
D

dabnat

Mike H - Do I need to put something in to reference the sheet the data is
coming from "active" and not the sheet where the data will show?
 
T

T. Valko

If the formula is on a different sheet than the referenced data, then yes.

=SUMPRODUCT((Active!C1:C1000="Marion")*(Active!H1:H1000="Estate sale"))
 

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

Count and Sum Functions based on multiple column criteria 1
Count Distinct Values based on criteria 4
Sum with multiple conditions 6
Trying to count based on multiple criteria & cell comparisons 4
count cells in a table that meet multiple criteria 0
Count rows based on multiple criteria 3
Count values 2
count dates 6

Top