Using SUMPRODUCT to show values like a pivot table

Mariux

New member
Joined
Jan 5, 2013
Messages
1
Reaction score
0
Points
0
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 :

Month_1Month_2Month_3
Client_1Cost_center1
Cost_center3
Client_2Cost_center1
Cost_center2
Cost_center3


Thanks for your support!
Looking forward to hearing from you.
 

Attachments

  • excel.jpg
    excel.jpg
    72.1 KB · Views: 86

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Post the workbook.
 
Top