Sum a range of cells

thank you both that's great! I'm glad I asked as I would not have worked that out very easily, I was determined to use sumif/sumifs

i was trying to use index match as well (unsuccessfully), would this type of formula work in these situations as well or was I barking up the wrong tree again

Originally Posted by NotTheBest

thank you both that's great! I'm glad I asked as I would not have worked that out very easily, I was determined to use sumif/sumifs

i was trying to use index match as well (unsuccessfully), would this type of formula work in these situations as well or was I barking up the wrong tree again

SUMPRODUCT formula is much simpler, SUMIF formula is much more complicated to write, please refer to
Cell E25 array formula , Drag down and across

HTML Code: