How do I set up an array using countif for 2 separate arguments.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the cell to count, but only if 2 separate arguments are met. Can that
be done?
 
Care to provide a bit more info, preferably by means of a tiny sample
along with the expected count?
 
Hi,

Name Dept Grade

Sam A 1
Patrick A 2
David A 1

If you want to count the number pf people who are in Department A and have
grade 1, enter the following formula

Array enter (Ctrl+Shift+Enter) the following formula in cell E10

SUM(IF((D6:D8="A")*(E6:E8=1),1,0))

Regards,
 
I tried this, but the formula didn't work. It just returns a value of 0.
BUT, I really think we are getting close. Any more ideas? Thanks.
 
The example is as Ashish wrote below, but the formula didn't work. It just
returns a value of 0. BUT, I really think we are getting close. Thanks.
 
The suggested formula should yield the count you need. Note that the
formula must be confirmed with control+shift+enter, not just with enter.
 
You must log in or register to reply here.

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

VLOOKUP & 2 arguments 8
Sorting array function explanation please 3
using CountIF function or Array? 3
Excel Need Countifs Formula Help 0
Can you use an INDEX array in a COUNTIF formula ? 1
Count data in adjacent cell if criteria met 0
Excel function - countif 2
Countif formula perhaps 7

Back
Top