Results 1 to 2 of 2

Thread: Using SUMPRODUCT to show values like a pivot table

  1. #1

    Using SUMPRODUCT to show values like a pivot table

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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_1 Month_2 Month_3
    Client_1 Cost_center1
    Client_2 Cost_center1

    Thanks for your support!
    Looking forward to hearing from you.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	excel.jpg 
Views:	84 
Size:	72.1 KB 
ID:	1014  

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Post the workbook.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts