If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|