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!

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!

Summing multiple hits using match, offset and index method
 

SUMIF doesn't seem to work for this. Any other suggestions?