Index help
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(INNING S!$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. |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com