G
Guest
Here's the formula that I have now.
=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$4000<=30),pseries!$T$8:$T$4000)
I need to make formulas for >30 <=60, then >60 <=90, etc so on down the road
every 30 days.
I've tried the one below but it doesn't seem to give me the answer.
=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$4000>31<61),pseries!$T$8:$T$4000)
=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$4000<=30),pseries!$T$8:$T$4000)
I need to make formulas for >30 <=60, then >60 <=90, etc so on down the road
every 30 days.
I've tried the one below but it doesn't seem to give me the answer.
=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$4000>31<61),pseries!$T$8:$T$4000)