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

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