Forum Discussion
crb3209
Aug 02, 2024Copper Contributor
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 "Standalone Service"
Criteria 3: If either columns AA or AB have August in the date
Here's the formula I'm trying to work with
=SUMPRODUCT((Master_Calendar!$F$3:$F$503="Standalone Service")*(Master_Calendar!$C$3:$C503="YES")*((MONTH(Master_Calendar!$AA$3:$AA$503)=8)+(MONTH(Master_Calendar!$AB$3:$AB$503)=8)))
I don't know what I'm doing wrong
Thanks
- 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))
- crb3209Copper ContributorThank you, Rodrigo. I think I've been staring at it too long. I fixed it, but it still doesn't work.
- Rodrigo_Steel Contributoruse 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))