Results 1 to 14 of 14

Vlookup and sumifs or pivot table?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    Vlookup and sumifs or pivot table?

    hi guys
    Here's a tuff one
    My clients pays me a fee every month for the service i provide to them.
    I have several teams who are working on its project.
    Each person has a cost per hour.
    If i have total hours worked for each person on each client, knowing what is his cost per month for workers and clients, i may know if i'm charging too much or too litle for each client, right?

    That's what i wanna know.

    I have my database with how many hours for each person worked on each client. Each person has a monthly hour cost as well as each client.

    To obtain the final output that i want, see file attach please, what's your best choice to solve this?

    Best regards
    Pedro
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumifs formula referencing cell generated by slicer/pivot table
    By 3345james in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2015, 03:26 PM
  2. sumifs on a pivot table - compare range with range
    By pavlos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 02:26 AM
  3. Some sort of sumifs to remove pivot table
    By benoj2005 in forum Excel General
    Replies: 3
    Last Post: 09-11-2012, 04:07 AM
  4. SUMIFs pivot table by column
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 09:50 PM
  5. VLOOKUP from Pivot table?
    By Jeanapeana in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2009, 03:47 AM
  6. [SOLVED] vlookup in a pivot table
    By Matt Lunn in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 03:05 PM
  7. vlookup in a pivot table
    By Matt Lunn in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 AM

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