Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update daily count
I have a muli-tab workbook to track my sales team's progress against goal.
I'd like to have one tab dedicated to daily sales and have those numbers "added" to the master spreadsheet. Right now if I cut and paste the daily sales report into my daily sales tab my formulas only update my numbers. I need them to be added to previous total. For example if my current month total is 100 and today we sold 10 more I need the result to be 110. But right now the 100 is replaced with 10. Thanks, Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update daily count
Hi,
Well we really need more info. But here is a shot. Suppose the numbers are in column D that you are totalling to 100 and the formula is =SUM(D2:D35) Change the formula to read =SUM(D2:D10000) and you are ready for any number of records. -- If this helps, please click the Yes button Cheers, Shane Devenshire "judynsteve" wrote: I have a muli-tab workbook to track my sales team's progress against goal. I'd like to have one tab dedicated to daily sales and have those numbers "added" to the master spreadsheet. Right now if I cut and paste the daily sales report into my daily sales tab my formulas only update my numbers. I need them to be added to previous total. For example if my current month total is 100 and today we sold 10 more I need the result to be 110. But right now the 100 is replaced with 10. Thanks, Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update daily count
Thanks Shane here's more information. Workbook has 3 tabs; summary, account
list, and daily count (updated daily). The account worksheet uses vlookup formulas to reference the daily count worksheet. The account numbers are totaled by territory and added to the summary worksheet which then tracks the territory's progress against the sales goal. Everything is calculating perfectly. What I'd like to do - if possible - is to cut and paste each daily count into the daily count worksheet (over write) and have the account worksheet add the daily count to the number already present (yesterday's daily count) For example if an account generated 1 unit each day and I copied and pasted the daily count into the daily count worksheet the total on Friday would be 5 (Mon-Fri) Right now the result on Friday would be 1. I want to keep the workbook as simple as possible but short of creating 31 columns full of Vlookup formulas referencine 31 daily count worksheets I'm at a loss. Thanks for taking the time to ponder my Excel dream. Steve "Shane Devenshire" wrote: Hi, Well we really need more info. But here is a shot. Suppose the numbers are in column D that you are totalling to 100 and the formula is =SUM(D2:D35) Change the formula to read =SUM(D2:D10000) and you are ready for any number of records. -- If this helps, please click the Yes button Cheers, Shane Devenshire "judynsteve" wrote: I have a muli-tab workbook to track my sales team's progress against goal. I'd like to have one tab dedicated to daily sales and have those numbers "added" to the master spreadsheet. Right now if I cut and paste the daily sales report into my daily sales tab my formulas only update my numbers. I need them to be added to previous total. For example if my current month total is 100 and today we sold 10 more I need the result to be 110. But right now the 100 is replaced with 10. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update daily sheet | Excel Worksheet Functions | |||
Daily cell update | Excel Discussion (Misc queries) | |||
how do i automatically update % figures daily | Excel Discussion (Misc queries) | |||
How do I do a formula to update numbers daily? | Excel Worksheet Functions | |||
Auto update daily report problem | Excel Discussion (Misc queries) |