Index/Match/Sumifs?

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