Results 1 to 2 of 2

Thread: Weighted Average Summary Table

  1. #1
    Neophyte srdavisgb's Avatar
    Join Date
    Jul 2018
    Posts
    3
    Articles
    0
    Excel Version
    Excel 2016

    Weighted Average Summary Table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to calculated the weighted average for each item in a worksheet (columns A:E in the attached file). I have created a summary table to identify each item (columns G:H). The formula in cell H4 does not work.

    How do you join an if statement with the SumProduct function?

    Thanks in advance for your assistance.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =SUMPRODUCT(--($A$4:$A17=$G4),$D$4:$D$17,$E$4:$E$17)/SUMIF($A$4:$A$17,G4,$D$4:$D$17)

    copied down


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •