Forum Discussion
Solved
Sumproduct with three criteria, one of which is an or statement with two dates
Hi everyone, This is a complex endeavor for me. I am attempting to use sumproduct with three criteria on another tab. Criteria 1: If column C indicates "YES" Criteria 2: If column F indicates "St...
- use this formula,
=SUMPRODUCT((Master_Calendar!$C$3:$C$503="YES")*(Master_Calendar!$F$3:$F$503="Standalone Service")*(((MONTH(Master_Calendar!$AA$3:$AA$503)=8)+(MONTH(Master_Calendar!$AB$3:$AB$503)=8)) > 0))
crb3209
There's a small discrepancy in your formula:
Master_Calendar!$C$3:$C503 >>> Master_Calendar!$C$3:$C$503
Thank you, Rodrigo. I think I've been staring at it too long. I fixed it, but it still doesn't work.
- use this formula,
=SUMPRODUCT((Master_Calendar!$C$3:$C$503="YES")*(Master_Calendar!$F$3:$F$503="Standalone Service")*(((MONTH(Master_Calendar!$AA$3:$AA$503)=8)+(MONTH(Master_Calendar!$AB$3:$AB$503)=8)) > 0))