Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |