Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month to date sales - reset in new month???
Hi all,
I have a column that lists daily sales on an ongoing basis. I need to create a second column which tracks month to date sales (so it will grow throughout the month). The catch is I need this column to automatically reset and start counting again when the daily date becomes a new month. This must be possible, but I can't figure it out. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month to date sales - reset in new month???
=SUMPRODUCT(--(YEAR($A$1:A1)=YEAR(A1), (--(MONTH($A$1:A1)=MONTH(A1),
$B$1:B1) and just copy down -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ups.com... Hi all, I have a column that lists daily sales on an ongoing basis. I need to create a second column which tracks month to date sales (so it will grow throughout the month). The catch is I need this column to automatically reset and start counting again when the daily date becomes a new month. This must be possible, but I can't figure it out. Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month to date sales - reset in new month???
If your columns are Date (A), Sales (B), and MTD Sales (C), with a header row
1, I'd start in cell C2 with =B2. Then in cell C3, =b3 + if(month(a3)=month(a2),c2,0). In words, the MTD sales through today are today's sales, plus the prior day's MTD sales as long as we're still in the same month. Copy that formula from C3 through the rest of column C. --Bruce " wrote: Hi all, I have a column that lists daily sales on an ongoing basis. I need to create a second column which tracks month to date sales (so it will grow throughout the month). The catch is I need this column to automatically reset and start counting again when the daily date becomes a new month. This must be possible, but I can't figure it out. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get month from date | Excel Discussion (Misc queries) | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Pulling a date in the current month | Excel Worksheet Functions | |||
Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
calcuate sales by date and segments | Excel Worksheet Functions |