Putting a COUNTA function in an Array Formula

  • Thread starter Thread starter brownie
  • Start date Start date
B

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
 
One way:

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

Array-entered.

HTH
Jason
Atlanta, GA
 
Back
Top