Sooner4Life
New Member
- Joined
- Mar 12, 2014
- Messages
- 15
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.
=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.