I'd like to use the SUMPRODUCT (or other formula) with certain conditions to show results in the similar shape of a pivot table.
I have a database "clients, cost-centers, months, revenues". For some of the clients we may have multiple cost-centers. I need the formula to show revenues depending on : clients, cost-centers, months alltogether in the same table, eventually in the matrix on the below table :
Thanks for your support!
Looking forward to hearing from you.
I have a database "clients, cost-centers, months, revenues". For some of the clients we may have multiple cost-centers. I need the formula to show revenues depending on : clients, cost-centers, months alltogether in the same table, eventually in the matrix on the below table :
Month_1 | Month_2 | Month_3 | ||
Client_1 | Cost_center1 | |||
Cost_center3 | ||||
Client_2 | Cost_center1 | |||
Cost_center2 | ||||
Cost_center3 | ||||
Thanks for your support!
Looking forward to hearing from you.