solved

Thanks for your prompt reply.

But if I needed it to look up the whole range, is it not possible as it is going across the 12 months with the addition of Q1-Q4?

All the ranges in Sumifs must be the same dimensions.
So you can't sum a multi-column range based on single-column criteria ranges.


Try
=SUMIFS(INDEX($E$2:$T$13,0,MATCH($B$19,$E$1:$T$1,0)),$A$2:$A$13,B23,$B$2:$B$13,$B$17,$C$2:$C$13,$B$18,$D$2:$D$13,$B$20)

That works great! Thanks

Jonmo1 if you dont mind me asking, could you explain briefly what the index and match functions do?

You're welcome.

INDEX($E$2:$T$13,0,MATCH($B$19,$E$1:$T$1,0))

Match finds which column has the value of B19 in row 1.
So if B19 = Q4, then MATCH returns 4 (it's in the 4th cell of E1:T1)

So we have
INDEX($E$2:$T$13,0,4)

INDEX returns the range intersecting at the specified Row# and Column# of the specified Range
INDEX(Range,Row#, Column#)
So if you did INDEX(A1:G10,3,4) you'd have D3 (3rd row 4th column)

When a 0 is used for the Row argument, then it returns a range that is ALL the Rows at the column specified
INDEX($E$2:$T$13,0,4) = the 4th column, All Rows = H2:H13


The reverse is true if you put a number in the Row argument, and 0 in the Column
INDEX($E$2:$T$13,4,0) = Row 4, All Columns = E5:T5. (Row 5 is the 4th row of E2:T13, 2 is the first, 3 is the 2nd, 4 is the 3rd)

Hope that helps.

That is great! Thanks for the helpful understanding.

You're welcome.