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!