View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default build a formula that references other worksheets

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


"Paw" wrote:

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...