# Thread: Count with multiple criteria (2002)

1. ## Count with multiple criteria (2002)

Edited by HansV to provide more descriptive subject

Hi everyone
I'm trying to count the occurences of two different things in two columns =COUNT(IF((C3:C120=G2),(E3:E120=G8))) I've set this as an array but no joy. gives me a 0 or some strange result.
I've also tried this but nada =COUNT(IF((C1:C120=G2),AND(E1:E499=G8)))
I kinda understand that countif wont do mutiples and someone suggested dcount but I'm getting lost.
I hope this makes sense?
thanks so much

2. ## Re: Count with multiple criteria (2002)

Welcome to Woody's Lounge!

The formula would be

=SUMPRODUCT((C3:C120=G2)*(E3:E120=G8))

or as an array formula (confirm with Ctrl+Shift+Enter)

=SUM((C3:C120=G2)*(E3:E120=G8))

but it doesn't make much sense since G8 is empty in all worksheets.

3. ## Re: Count with multiple criteria (2002)

Thanks a lot Han's.
I tried it and it works
Dont know why G8 was empty in what I sent you(it was the 4th worksheet in).
I always think of Sum to be add up aritmetically not count occurences of.
And * (multiplied) by also threw me but I'm wiser now.
thanks for making my 5 hours on a Friday night a wise investment![img]/forums/images/smilies/smile.gif[/img]

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•