=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$400030),--(pseries!$S$8:$S$4000<=60),pseries!$T$8:$T$4000

=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$400060),--(pseries!$S$8:$S$4000<=90),pseries!$T$8:$T$4000

etc

"Toppers" wrote:


=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$400031),--(pseries!$S$8:$S$4000<61),pseries!$T$8:$T$4000)



"Karen Smith" wrote:

Here's the formula that I have now. I need to make formulas for 30 <=60
and so on down the road every 30 days.

=SUMPRODUCT(--(pseries!$I$8:$I$4000="advertising"),--(pseries!$S$8:$S$4000<=30),pseries!$T$8:$T$4000)

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$400031<61),pseries!$T$8:$T$4000)

Can anyone help?


"Karen Smith" wrote:

I need to create 2 formulas on the following table ....1 how many records are
0-30 days (answer 4) and 2ndly how much money are in 0-30 days (answer $750)

For example
# of Days $
28 150
34 100
22 100
44 100
1 200
32 50
5 300