Calculating multiple worksheet in one workbook

D

dluttrell

I have a workbook that has so far 6 worksheets. On every worksheet but the first I would like to calculate year-to-date totals for about 4 different cells. That is each cell when inputted with information will show the year-to-date totals. I have used the =sum(.....) but I get a message about circular formatting or something like that. It is very important that I get this done ASAP. Any help would be greatly appreciated

Thanks!
 
B

Bernard V Liengme

Could you try explaining that again. The message and the header do not seem
to agree.
A Circular Reference is when a formula refers to itself. So if in A10 you
have=SUM(A1:A10), Excel has no idea what to do.
Bernard

dluttrell said:
I have a workbook that has so far 6 worksheets. On every worksheet but
Click to expand...
the first I would like to calculate year-to-date totals for about 4
different cells. That is each cell when inputted with information will show
the year-to-date totals. I have used the =sum(.....) but I get a message
about circular formatting or something like that. It is very important that
I get this done ASAP. Any help would be greatly appreciated.
 

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

Year End totals 7
Auto Sum not working correctly 1
Multiple logic functions with multiple sums 2
How do I find like data in multiple worksheets? 1
Calculate end date and time 1
How do I create a graph from a worksheet? 2
Drop Down List Dependant Formula 2
New computer, how do i move outlook 365 ENTIRELY? 0

Top