I am using the following formula in all of the cells of column "Out" of Table A:
=IFERROR(INDIRECT("Table B :: B"&MATCH($A2,Table B :: $Date,0)),"")
The formula looks to match the date in the cell to the left in the column "Date" with a date in column "Date" of Table B:
If it makes the match it returns the value in the cell to the right of the date in column "Out" of Table B.
The problem is that if there is more than one row with the same date (as there is in Table B above) the formula only returns the first value, when I would like it to SUM multiple values if more than one instance of a date occurs in Table B.
Is there a way of achieving the result I am looking for, as I can't get my head round other possibilities?