Hi
I've attempted to use SUMIFS on the attached to select certain criteria to pull out a value. I don't think my approach is correct.
From the 'Journal' worksheet, cell F16, I would like the formula to sum the relevant value from 'Projections' worksheet, based on the following criteria:
'Journal' worksheet cell B6 to 'Projections' worksheet cell range C5:N5
'Journal' worksheet cell A16 to 'Projections' worksheet cell range C6:N13
Would appreciate if someone could take the time to advise me on this
Many thanks, Maddy
Excel Forum - Sumif_Index_Match.xlsx
Bookmarks