Sumifs Question

[Sooner4Life]

This is probably a simple fix but I cannot figure it out..

=SUMIFS(U3:U41,AH3:AH41,""=FALSE,AI3:AI41,""=FALSE)

I'm needing the sum of U3:U41 unless AH3:AH41 and AI3:AI41 are both True. Right now if one is true and the other is not that line is not counted. Hopefully that makes sense.

 

[Eric W]

One way:

=SUMPRODUCT(U3:U41,1-(AH3:AH41*AI3:AI41))

If you want to stick with SUMIFS, then maybe:

=SUM(U3:U41)-SUMIFS(U3:U41,AH3:AH41,TRUE,AI3:AI41,TRUE)

 

[Sooner4Life]

One way:

=SUMPRODUCT(U3:U41,1-(AH3:AH41*AI3:AI41))

That got it. Thank you so much!

 

[Eric W]

Happy to help! Thanks for the feedback. ?