Multiple criteria within one criteria range

[pywhacket]

Hello,

I need to select two criteria from a range for a SUMIF statement. Where it is: Data!$H:$H,"A" - I need it to look for A and E

=IF($C5="X",1,0)*(SUMIFS(Data!$L:$L,Data!$A:$A,'Band 1-Transition PWS Summary'!$A5,Data!$C:$C,1,Data!$H:$H,"A",Data!Y:Y,"Band 1"))

 

[Haseeb Avarakkan]

Hello, Try

=($C5="X")*SUM(SUMIFS(Data!$L:$L,Data!$A:$A,'Band 1-Transition PWS Summary'!$A5,Data!$C:$C,1,Data!$H:$H,{"A","E"},Data!Y:Y,"Band 1"))

 

[pywhacket]

Wonderful! Thanks so much!!