Sumifs/or

[uwish7]

I have heard about using sum(sumif) but in the examples, they use the value. I want to use the cells. Can someone please fix this formula for me please? =SUMIFS(Output!$H:$H,Output!$C:$C,$B4,Output!$B:$B,$C4,Output!$E:$E,$E4,Output!$F:$F,H$1)+SUMIFS(Output!$H:$H,Output!$C:$C,$B4,Output!$B:$B,$C4,Output!$F:$F,$F4,Output!$F:$F,H$1)

I will prefer to have it read: =SUMIFS(Output!$H:$H,Output!$C:$C,$B4,Output!$B:$B,$C4,Output!$E:$E,($E4,$F4),Output!$F:$F,H$1)

 

[Aladin Akyurek]

One way:

=SUMPRODUCT(SUMIFS(Output!$H:$H,Output!$C:$C,$B4,Output!$B:$B,$C4,Output!$E:$E,$E4:$F4,Output!$F:$F,H$1))

 

[uwish7]

Thank you. It worked

 

[Aladin Akyurek]

Thank you. It worked

You are welcome.