Summing multiple hits using match, offset and index method

Hi,

I have the following:

=SUM(OFFSET(INDEX(MY_SHEET_REF,MATCH($B16,MY_COL_REF,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!

Maybe use the sumif function.

What do you think this does

=ABCDGH J29RKM28



--
Regards,
Tom Ogilvy

<[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have the following:
>
>
=SUM(OFFSET(INDEX(MY_SHEET_REF,MATCH($B16,MY_COL_REF,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!
>

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