| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum current months values
Thanks for the replies.
Tom I assume your "enddate" could be a cell value... Thanks again. "Tom Ogilvy" wrote: =sumif(A:A,"<="&EndDate,C:C)-Sumif(A:A,"<"&StartDate,C:C) would be one way. -- Regards, Tom Ogilvy "John" wrote in message ... If Column A is dates for this year (1-1-05, 1-2-05,...) and column C is values corresponding to those dates. How can I sum this months values only (so that next month it will do the same without changing my sum range). If it helps, I have the start and end day of the month in two cells... Thanks for the help. John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| current average turnover by months | Excel Worksheet Functions | |||
| In a range of months can I capture the most current month entry? | Excel Discussion (Misc queries) | |||
| Automatically update charts for only the most current 12 months? | Charts and Charting in Excel | |||
| sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
| Dates to months and calculating values for their months | Excel Programming | |||
Threaded Mode
