formula to work in a 3-d reference with 2 work books

C

capt c

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
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
multiple sheets 2 work books 0
Referencing relative to a formula reference 3
Work center hours 1
Why doesn't this work ? 2
Row reference for consecutive series calculation 0
Calculating nr of books a certain author has published 2
Can't Get Formula to work 0

Top