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

​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 dateHere’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  Read More

​