J
Jambruins
I have a tab called INNINGS with a team names in column AC and numbers in
cells AD and AE. There a more than one occurance of each team. I have
another tab with a team name in cell A1. In cell F2 I have this formula
=IF(COUNTIF(INNINGS!$AC$1:$AC$50000,$A$1)>=ROWS($1:24),INDEX(INNINGS!$AC$1:$AC$50000,SMALL(IF(INNINGS!$AC$1:$AC$50000=$D$1,ROW($1:$50000)),ROWS($1:24))),"")
which gives me the team name but I want it to give me the total of cells AD
and AE instead of the team name. Any idea how to modify my formula to do
this? Thanks.
Please ask if you don't quite understand my question. Thanks.
cells AD and AE. There a more than one occurance of each team. I have
another tab with a team name in cell A1. In cell F2 I have this formula
=IF(COUNTIF(INNINGS!$AC$1:$AC$50000,$A$1)>=ROWS($1:24),INDEX(INNINGS!$AC$1:$AC$50000,SMALL(IF(INNINGS!$AC$1:$AC$50000=$D$1,ROW($1:$50000)),ROWS($1:24))),"")
which gives me the team name but I want it to give me the total of cells AD
and AE instead of the team name. Any idea how to modify my formula to do
this? Thanks.
Please ask if you don't quite understand my question. Thanks.