Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
help on INDEX | Excel Discussion (Misc queries) | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
index/index | Excel Worksheet Functions | |||
Using INDEX twice?? | Excel Worksheet Functions |