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...
Do you have an actual workbook already going? It would be a lot easier to show you how to do this with that actual, rather than re-creating from your example. So long as there's no proprietary info on it (or private info) you can post it here.
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.