+ Reply to Thread
Results 1 to 9 of 9

How to calculate the weightage using 3 parameters

  1. #1
    Registered User
    Join Date
    12-04-2010
    Location
    India , India
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to calculate the weightage using 3 parameters

    I am not able to figure out a formula for calculating the weightage of a value depending on 3 parameters . Attached is the problem .. Kindly help me out ....
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to calculate the weightage using 3 parameters

    Using XL2003 a quick means of doing this (avoiding [inefficient] SUMPRODUCT etc)

    Please Login or Register  to view this content.
    If you are using XL2007 (implied by forum if not your profile) then use SUMIFS as divisor:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-04-2010
    Location
    India , India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to calculate the weightage using 3 parameters

    Thanks for the reply .. Actually I am using excel 2003 in office where I need this .... but using 2007 at home so posted in wrong forum ...

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to calculate the weightage using 3 parameters

    FYI: thread moved to Worksheet Functions forum

  5. #5
    Registered User
    Join Date
    12-04-2010
    Location
    India , India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to calculate the weightage using 3 parameters

    E2:
    =$D2/SUMIF($F:$F,$F2,$D:$D)

    The formula for excel 2003 is not working ... can u give me the details ...

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to calculate the weightage using 3 parameters

    All the information you require (based on sample & question) has been provided.
    If you are unable to get the 2003 suggestion to work post a further sample with prior suggestions in place.

  7. #7
    Registered User
    Join Date
    12-04-2010
    Location
    India , India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to calculate the weightage using 3 parameters

    I am a newbie to excel ... I have given a data till column D but the formula you have given for 2003 includes column F and when am typing that formula it is giving error ... So only i asked ... the formula for 2007 is working fine ... do correct me if am wrong ...

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to calculate the weightage using 3 parameters

    to save time/further confusion
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    12-04-2010
    Location
    India , India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to calculate the weightage using 3 parameters

    I took that there were 2 different formulas but didn't checked that both were to be used together ... Thanks for your help ... now my query is resolved ...

+ 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