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