build a formula that references other worksheets

[Guest]

In my budget worksheet I have a balance column and I need to subtract budget
amounts from other worksheets from my beginning balance. When I was using
QPRO my formula looked like this:
@Sum(C8,-@Sum(1090:F103,Applegate:F20,Armstrong:F20,Binning:F20))
C8 was my beginning budget and the rest (there were more that was listed in
my formula, but I did not want to waste space) were my other worksheet
balances. But I do not know how to write this formula in Excell I keep
getting error messages.
Thank you for any help...

 

[T. Valko]

Try this:

=C8-SUM('1090'!F103,Applegate!F20,Armstrong!F20,Binning!F20)

You don't need @ signs.

Excel uses ! as the sheet name identifier. Sheet names that are numbers,
1090, or have spaces in them, Week 1, need to be enclosed in single quotes:
'1090' , 'Week 1'.

Biff

 

[Guest]

The Excel equivalent to your formula would look like this:

=C8-1090!F103-Applegate!F20-Armstrong!F20-Binning!F20

The use of the SUM function is not necessary since you're only using single
cell references. Also, note that if any of your worksheet names contain
spaces, then you'll need to enclose the name in single quotes. For example:
'Apple Gate'!F20

And here's a suggestion that may help depending how your workbook is setup.

=C8-1090!F103-SUM('First Sheet:Last Sheet'!F20)

This will add the F20 cells of all sheets starting with 'First Sheet' and
ending with 'Last Sheet'.

HTH,
Elkar