Results 1 to 15 of 15

Using SUMPRODUCT to show values like a pivot table

Threaded View

  1. #1
    Banned User!
    Join Date
    01-05-2013
    Location
    Romania
    MS-Off Ver
    Excel 2007
    Posts
    8

    Using SUMPRODUCT to show values like a pivot table

    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 attached excel.

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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1