SUMIFS to look up column rather than row

[Taryn]

I need my SUMIFS formula to look up column data AND row data to return a result, is this possible?

I have typed in a formula in cell B4 of the OUTPUT tab but it obviously doesn't work, any help would be greatly appreciated

 

[ETAF]

how about something like
=SUMPRODUCT((Data!$Q$7:$AL$17)*(Data!$D$7:$D$17=OUTPUT!B$2)*(Data!$Q$6:$AL$6=OUTPUT!$A4))

but i'm not following your formula for sumif

i have added some values - to show the results

 

[Taryn]

Amazing thank you so much!

 

[ETAF]

you are welcome

 

[bosco_yip]

Or,

Try to use Sumif function instead

In B4, formula copied across and down:

=SUMIF(Data!$D:$D,B$2,INDEX(Data!$1:$1,MATCH($A4,Data!$6:$6,0)))