• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Weighted average using sumproduct formula

    Thanks for the response. My formula logic was wrong - you are correct it should have been sum(b1:b2) <smacks forehead> I suppose this is why a little bit of knowledge is a dangerous thing... Many thanks for solving my problem!
  2. D

    Weighted average using sumproduct formula

    Data: # of calls (column B) = 23,808 with average hold time (column M) of 49 seconds 6,851 10 seconds I built a sumproduct formula =sumproduct(B1:B2,M1:M2)/sum(M1:M2) Column M is custom format mm:ss My answer keeps coming out 47:10. Shouldn't...
Back
Top