I have a function:
Which looks at cell A8 on sheet 'Matis' and checks what it is against a series of cells on the sheet the function is written, and returns a value based on what it finds.
For example, it looks at Matis!A8, and sees that it is equal to B11, and returns 8.
I'm trying to make it such that the function looks down from say A8:A100 on 'Matis' and sums up the result for each cell.
For example if it looked at A8 and returned 8, A9 and returned 10, A10 and returned 10, the function would return 8+10+10=28.
Currently I just print all the results to a different column by dragging the formula down, then sum that column, but I'd like all this to be done in one cell
I've seen SUMIF, SUMIFS and SUMPRODUCT around, but I'm not sure which one, if any of them I should be using here. Anyone got any hints? I hope I explained this well enough.