keeping sum after deleting the added numbers

B

Brett

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.
 
B

Brett

I was hoping that I wouldn't have to do that. I just want to delete the
information that I added without losing the sum
 
M

Marcelo

OK,

If you delete the data, the sum will be zero. the only way is, copy and
paste special values, but have notice that you will lose the formula and to
sum the next month data you will to edit using:

assuming that the total of the first month was 123.456,00

you will have =123456+sum(b2:b6000)

hth

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:
 
B

Brett

Thanks

Marcelo said:
OK,

If you delete the data, the sum will be zero. the only way is, copy and
paste special values, but have notice that you will lose the formula and to
sum the next month data you will to edit using:

assuming that the total of the first month was 123.456,00

you will have =123456+sum(b2:b6000)

hth

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:
Click to expand...
 
M

Marcelo

happy to help, tanks for the feedback


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An odd problem with SUM(A:B) and AutoSum 2
Sum months into quarters? 3
link data that changes each month 1
Formula Help... 2
Calculating Monthly returns based on Dates 4
SUMIF with NAME RANGE 1
data from sheet to sheet automatically 1
EOMONTH as test criteria 3

Top