Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
build a formula that references other worksheets
Try this:
=C8-SUM('1090'!F103,Applegate!F20,Armstrong!F20,Binnin g!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 "Paw" wrote in message ... 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... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Build Formula | Excel Worksheet Functions | |||
How can I build a pivot table from multiple worksheets which are . | Excel Discussion (Misc queries) | |||
How would I build an "if" formula... | Excel Worksheet Functions | |||
Trying to build a formula | Excel Worksheet Functions |