Dynamic updating of fields between worksheets

Hi all, first post on this forum so hoping you are all as helpful as some of the other fine people on other forums I use :-D

I've been asked by a colleague if it is possible to have *say* a running total field on one worksheet which will be updated by the sum of the total fields in other worksheets in the same spreadsheet file. It seems like a fairly fundamental thing to want to achieve but none of us can work out how. If anyone could advise I'd be very grateful indeed.

Many thanks

Adam

Can't help much without more details.

Basically it sounds like you have several spreadsheets in a workbook. Each spreadsheet calculates a total for that sheet. What you want to do is take each of the totals from the individual sheets and sum the totals. My first impression would be to us a formula to extract each of the totals from the other sheets into the sheet where you want to add them all together. Not knowing exactly how your workbook is laid out, it's real hard to know how to do this.

Once you have all the totals into your "summary" sheet, then a simple sum function should add them up.

Hi Mr Shorty, thanks for your reply. I guess my question really is more general...

What I don't know how to do is to reference cells in different worksheets in a formula. So say I have a spreadsheet containing Worksheet A, B and C, how do I actually include a field from Worksheets B and C in a formula being created in Worksheet A? Hope this makes sense.

Thanks again

Adam

The basic syntax is ='sheet1'!A1. The single quotes aren't always necessary, but they are necessary if your sheet name includes non-alphabetic, non-numeric characters.

For people new to/unfamiliar with Excel. The easiest way is probably to type = in the cell, then simply navigate to the desired reference. Excel will then include the reference as a relative reference. You can then use the F4 key to change to various absolute references, if you want, then hit enter.

That's excellent many thanks for your help I really appreciate it