Running total across worksheets...

[pjd813]

I'm not a spreadsheet jockey. I do not see this solution in the help files. Maybe I'm looking in the wrong place.

I have a spreadsheet that has a "total Due" field. I Have multiple worksheets in a workbook. How do I keep an automatically updated running total of the "total due" fields on the most current worksheet?

Thanks !
Pete D.

 

[JE McGimpsey]

I'm not a spreadsheet jockey. I do not see this solution in the help files.
Maybe I'm looking in the wrong place.

I have a spreadsheet that has a "total Due" field. I Have multiple worksheets
in a workbook. How do I keep an automatically updated running total of the
"total due" fields on the most current worksheet?

If your "total due fields" are in the same cell for each worksheet
(e.g., cell Z50), then you can sum them as

=SUM(FirstSheet:LastSheet!Z50)

where FirstSheet is the name of the leftmost sheet to start at, and
LastSheet is the rightmost.

If the "total due fields" are in different locations on each sheet,
you'll need to provide more information on how your data is laid out.