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.

"Ashish Mathur" wrote:

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,

"crich" wrote:

I want the cell to count, but only if 2 separate arguments are met. Can that
be done?