need formula help
 

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

need formula help
 

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

"p-nut" wrote:

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

need formula help
 

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))*(r ngA<DATE(YEAR(U5),MONTH(U5)+1,15)*1))
to sum
=SUMPRODUCT((rngA=DATE(YEAR(U5),MONTH(U5),15))*(r ngA<DATE(YEAR(U5),MONTH(U5)+1,15)*rngD))


--
Don Guillett
SalesAid Software

"p-nut" wrote in message
...
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