+ Reply to Thread
Results 1 to 2 of 2

conditional sumproduct

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    2

    Lightbulb conditional sumproduct

    I have engineer wise performance scorecard. I want to get manager wise scorecard taking every engineer from the team into account for the particular manager.
    Manager name employee Name Sample Score (AVG)
    A c 2 90%
    A d 3 85%
    A e 4 80%
    A f 3 52%
    A g 4 60%
    B h 5 29%
    B i 10 39%
    B j 2 89%
    B k 4 95%
    B l 5 36%

    How do I get overall score for Manager A and Manager B...basically manager score card derived from overall engineer scores....

  2. #2
    Registered User
    Join Date
    04-17-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: conditional sumproduct

    what should be the formulae, I tried with sumproduct and sumproduct if together...However, I am not able to get the actual formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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