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