need formula help

[Guest]

Hello,

I am trying to figure out how to add the daily totals from the 15th of one
month thru the 15th of the next month. I think I can figure out how to do
the 15th of january to the 15th of february, the 15th of february to the 15th
of march, etc, etc. If you could help with that, that would be greatly
appreciated, but my main question is how to do the 15th of december of 2006
to the 15th of january 2007?

You can check my previous post for the first part of my total overall
question. Also to see the list of numbers that I am talking about.

Thank you very much for any help in advance.

Tim

 

[Guest]

Hi,

Don't know how your data is setup but try something like:

=SUMPRODUCT((A1:A100>=DATE(2006,12,15))*(A1:A100<=DATE(2007,1,15)),B1:B100)

HTH
Jean-Guy

 

[Don Guillett]

correct for word wrap & range where u5 has a valid date for the current
month

to count
=SUMPRODUCT((rngA>=DATE(YEAR(U5),MONTH(U5),15))*(rngA<DATE(YEAR(U5),MONTH(U5)+1,15)*1))
to sum
=SUMPRODUCT((rngA>=DATE(YEAR(U5),MONTH(U5),15))*(rngA<DATE(YEAR(U5),MONTH(U5)+1,15)*rngD))