Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to work in a 3-d reference with 2 work books
I originally had a sumif formula working with 2 work books however when i
attempted to apply it to more than one sheet in the one work book it would not allow me to do so (because of the 3-d reference. workbook 1 is the main data gathering database. work book 2 is where i have multiple sheets where as if column "c" is equal to certain text than multiply column "d" by x. any ideas???????? please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to work in a 3-d reference with 2 work books
On each sheet, in the same cell reference, place your SUMIF formulas. Note
that by first selecting all sheets, and then inputting formula, you can save some keystrokes. Now you can use a 3D SUM function to add up all the different SUMIF's. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "capt "c"" wrote: I originally had a sumif formula working with 2 work books however when i attempted to apply it to more than one sheet in the one work book it would not allow me to do so (because of the 3-d reference. workbook 1 is the main data gathering database. work book 2 is where i have multiple sheets where as if column "c" is equal to certain text than multiply column "d" by x. any ideas???????? please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
link work books | Excel Discussion (Misc queries) | |||
work books only reference sheets in same folder... | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Work books | Excel Worksheet Functions |