Adding values for prior date intervals
 

I apologize my cell ranges are actually D150:D269 and E150:E269. I tried this
formula which is the closest thing I can think of but I get a #value error.



SUMPRODUCT(($D$150:$D$269=DATE(YEAR(TODAY()),MONT H(TODAY())-2,DAY(TODAY())))*(DATE(YEAR(TODAY()),MONTH(TODAY() )-1,DAY(TODAY())))=$D$150:$D$269)*$N$150:$N$269)



"Qaspec" wrote:

In cells d7:D36 I have dates. In cells e7:E37 i have corresponding point
values. I can use sumproduct to provide a value for the last month from
today. I'd like to be able to get a formula that would provide me with the
month before the last. Here is what I am using to calculate the last month
from todays date.

=SUMPRODUCT(($D$150:$D$269=DATE(YEAR(TODAY()),MON TH(TODAY())-1,DAY(TODAY())))*(TODAY()=$D$150:$D$269)*$N$150:$ N$269)

I'd like to get the month before this one as well but I don't want to
combine the 2 months.