I need a formula to calculate returning players

  • Thread starter Thread starter BigBuck98
  • Start date Start date
B

BigBuck98

I have a file that has all of our little league players from last year. One
of the columns for these players is the division that they play in Minor,
Major, Junior, etc. I have inserted a new column and as these players signup
this year I put a "X" in that column.
I need a formula that will look at A2:A550, which is the column that has the
"X" in and also looks at column R2:R550 which has the division and tell me
how many players are returning for each division.
Thanks,
Gordon
 
Gordon,

Use the array formula, entered with Ctrl-Shift-Enter:

=SUM((R2:R550="Major")*(A2:A550="X"))

And use similar formulas to Junior, etc.

HTH,
Bernie
MS Excel MVP
 
Back
Top