Adding values for prior date intervals

[Guest]

In cells d736 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()),MONTH(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.

 

[Guest]

I apologize my cell ranges are actually D150269 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()),MONTH(TODAY())-2,DAY(TODAY())))*(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())))>=$D$150:$D$269)*$N$150:$N$269)