Comments on: How to calculate weighted average in Excel

The tutorial demonstrates two easy ways to calculate weighted average in Excel - by using the SUM or SUMPRODUCT function. Continue reading →

Comments page 2. Total comments: 47

  1. How would I make the first equation ignore 0% or blanks?

    1. I would use the IFBlank function

  2. how to calculate sum of basic salary of even no. of employee in excel

    1. Hello,
      For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
      Please also don't forget to include the link to this comment into your email.
      I'll look into your task and try to help.

  3. KG KG EUR
    0 2 2.8
    2.01 5 3.2
    5.01 10 3.8
    10.01 3
    more than 10kg i charge every 10kg 3 euros.
    what formula i have to use to find the cost for the weight e.g 35kg

  4. Hi I have 3 employees ,,, And i pay a bonus each week for the staff member who gets in the most " new sales " or "new customers".

    Now i give a score of 1 point for new once off customers.
    And i gave 2 points to the staff member who can get a new customer, but this new customer is a contractor and will very likely to come back for more in the future,

    for example . sales Staff Peter total new sale were 1000.00 and his point score was 7.

    Sales staff 2. John total new sales was 1200.00 and his point score was 5.

    Sales staff 3. Sam total sales were 800 and his points score was 9.

    So can you tell me who wins the bonus ?

  5. A worker is rated on a 1-5 scale for 10 different measures and his overall skill rating is the average of these numbers. The problem is that 3 of the measures are triple weighted and to further complicate matters, its possible for a worker to not be rated at all on one of the measures. This means the value isn't a 1, but a null value not factored into the overall average so as not to penalize them. How would you formulate this in excel?

  6. Hi, I need to average a set of course works to the original value. Let's say the course work valued 60 points but I gave 5 pieces of assignments that valued 70 points and at the end of the semester I want to average them to the original value. Usually if a student say got a total of 55 out of 70, I would calculate 55/70 X 60 = 47. So the student would get 47 out of 60. How do I put that formula in excel?

    Would really appreciate your help, my class has over 60 students.

  7. Can you replace a cell by group name in a formula? let say column A = group name and column B = $. How do you average an amount for each group not using the A1:A...but instead using Group Name such as Grapes, Peach, etc..

    Thanks

  8. Hi Svetlana,
    How would I modify this to take two different sets of weights into account? Would it be wrong to multiply the 2 weights for each row?
    Jo

  9. I'm trying to use the weighted average for a group of numbers between 500,000 and 999,999. Is is possible to use the weighted average for a range of numbers. If so, how?

  10. 1.2,2.2,3.3, these numbers are in one cell in excel .but how to do sum please explain please reply soon

    1. Am tring to learn how to calculate weight average

    2. =SUM(A1,A2) <-- will add A1 and A2 together
      =SUM(A1:A2,B1:B2) <-- will do (A1+A2)+(B1+B2)

  11. please tell me how to calculate in excel(basic calculation,office accounts)
    and also how to set calculation formats

  12. Well I find this site very useful

  13. How do I calculate the weight of each item
    Resource Part Schedule Production Remaining Overbuild Weight
    9003 3029093E 101002 88190 -12812 0
    1012 3029093E-ST 94231 48290 -45941 0
    1010 3035076E-ST 62374 62440 0 66
    1955 3031791E-ST 28180 84020 0 55840
    1958 3031330E-80S 23600 39590 0 15990
    1352 3032688B-ST 16816 74700 0 57884
    1350 3035077E-ST 12000 51600 0 39600
    1958 3031330E-80S 6600 50000 0 43400
    1350 3031413H-60S 0 49040 0 49040

  14. how to use the same in pivot

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)