Hi,
i attached my excel file.. can someone help me fill the formula for C13 then copied down.
The idea is to get match with Account and CostCenter then the sums are taken from A2 to J6
Same accounts between Column A und J can happen several times so these needs to sum it up together too..
if account matches with A2 Row to J2 row several times, then sum it up together aswell. then the next criteria is to get match with CostCenter
the Costcenter are shown in Column L so the row belongs to this specific cost center.
Account and costcenter needs to match up and then all matches will sum it up across several columns.
F12 - F18 are example results..
i dont know which formula suits for this better..?
i know there are better ways to design the layout, but that is how the layout template i need to work with.
thanks alot
Bookmarks