+ Reply to Thread
Results 1 to 2 of 2

Sum.if + weighted averages

  1. #1
    Registered User
    Join Date
    05-27-2015
    Location
    Lisbon, Portugal
    MS-Off Ver
    2013
    Posts
    1

    Sum.if + weighted averages

    Hi everyone,

    I've been trying to develop a calculation sheet where I can divide a fixed price through several products. The "program cost" should be divided by all the lines sharing the same value in a certain column according to a weighted average presented by another column.

    Explaining:

    Column C: Initial Price;
    Column F: Quantity;
    Column I: Program;

    Objective: Aggregate products by their program;
    Divide the program cost (10) by all of them considering their weighted average cost.

    I can't apply the weighted average function in the formula you see in my picture.

    Hope you've understand my problem and thank you in advance!


    EXCEL DOUBT.PNG

  2. #2
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Sum.if + weighted averages

    pls attach a sample file

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. weighted averages
    By runner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2013, 11:45 AM
  2. [SOLVED] Weighted Averages
    By MattCufre in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-01-2013, 12:18 PM
  3. Weighted Averages
    By par0016 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2013, 08:34 PM
  4. Weighted Averages Help
    By FCHunter82 in forum Excel General
    Replies: 4
    Last Post: 12-27-2010, 03:38 PM
  5. Weighted Averages
    By H57 in forum Excel General
    Replies: 2
    Last Post: 12-08-2010, 08:42 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