Calculating multiple worksheet in one workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top