update daily count

[judynsteve]

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

 

[Shane Devenshire]

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(D235)

Change the formula to read =SUM(D210000) and you are ready for any number
of records.

 

[judynsteve]

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