Hello,
I am hoping to tweak the Index-Match function to return a range by looking for a column then excluding certain rows so that I can sum it.
Put it simply I need a formula for the cells highlighted in red below and can be extended to the right.
Capture.JPG
Sorry for not uploading a whole excel workbook, there isn't any formula/macro that I need to show/include so I thought I'd keep it simple.
Any help would be much appreciated and thank you very much in advance!
Bookmarks