Putting a COUNTA function in an Array Formula

[brownie]

Data in Spreadsheet:
A B C
1 Plt Sqd Name
2 1st 1st Jones
3 1st 1st
4 2nd 3rd Nick
5 2nd 2nd Mary

I use an array formula to determine the number of
positions required in our organization as follows:
{=SUM(IF(A2:A5="1ST",IF(B2:B5="1ST",1,0)))}
This would return the value of 2.

Now what I need to do is expand on this array formula to
tell me how many people are assigned in column C to 1st
Sqd 1st Plt. I know how to use the COUNTA function, but
I'm perplexed as to how this is integrated in the array
formula.

Thank You

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A2:A5="1st")*(B2:B5="1st")*(C2:C5<>""))

 

[Jason Morin]

One way:

=SUM((A2:A5="1st")*(B2:B5="1st")*(C2:C5<>""))

Array-entered.

HTH
Jason
Atlanta, GA