Count based on two different criteria
 

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?

Count based on two different criteria
 

Try,

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

Mike

"dabnat" wrote:

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?

Count based on two different criteria
 

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?

"Mike H" wrote:

Try,

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

Mike

"dabnat" wrote:

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?

Count based on two different criteria
 

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

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


--
Biff
Microsoft Excel MVP


"dabnat" wrote in message
...
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?

"Mike H" wrote:

Try,

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

Mike

"dabnat" wrote:

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?