| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing multiple hits using match, offset and index method
Hi,
I have the following: =SUM(OFFSET(INDEX(MY_SHEET_REF,MATCH($B16,MY_COL_R EF,0),MATCH(D$3,MY_OTHER_COL_REF,0)),0,0,1,A$2)) To sum a several columns after a cell matches my search criteria. However, if I have several valid cells that match the search, only the first is returned. How can I sum the offset for multiple hits of the same index search (maybe a totally different method is needed)? Many thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing multiple hits using match, offset and index method
Maybe use the sumif function.
What do you think this does =ABCDGH J29RKM28 -- Regards, Tom Ogilvy wrote in message oups.com... Hi, I have the following: =SUM(OFFSET(INDEX(MY_SHEET_REF,MATCH($B16,MY_COL_R EF,0),MATCH(D$3,MY_OTHER_C OL_REF,0)),0,0,1,A$2)) To sum a several columns after a cell matches my search criteria. However, if I have several valid cells that match the search, only the first is returned. How can I sum the offset for multiple hits of the same index search (maybe a totally different method is needed)? Many thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing multiple hits using match, offset and index method
SUMIF doesn't seem to work for this. Any other suggestions?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset/Index/Match ... or something? | Excel Discussion (Misc queries) | |||
| Index/Match/Offset/Sum (maybe?) | Excel Discussion (Misc queries) | |||
| OFFSET vs INDEX(MATCH(...)) | Excel Discussion (Misc queries) | |||
| index match offset? | Excel Worksheet Functions | |||
| Index, Match, Offset? Not sure which to use | Excel Worksheet Functions | |||
Linear Mode
