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?