Forum Discussion
Populating Cells with data from different area
So forgive me if this doesn't make sense, I am not sure exactly how to explain what I want to do. Basically this file is used to track transfers between departments, what we do is input each transfer...
Try this, I do not think there is any proprietary info but I have change dept names for simplicity. mathetes
I think the SUMIF function is the one you need. That's what I've used in the attached, and it seems to be producing the right results.