+ Reply to Thread
Results 1 to 6 of 6

Sumproduct and Multiple Data (Daily, Weekly Data)

  1. #1
    Registered User
    Join Date
    08-03-2014
    Location
    Alberta, Canada
    MS-Off Ver
    2010
    Posts
    3

    Sumproduct and Multiple Data (Daily, Weekly Data)

    Hi Guys,

    I'd like to seek help in the sample table I have created as attached. While I understand that I can use Sumproduct to calculate the weighted average of a weight and a score, what formula should I be using to calculate the weighted average of say 5 days to calculate the End of Week weighted average? I was hoping that my data will not show an average of an average that's why I thought of using sumproduct but I am stuck with how I can get the end result for a week's data.

    Appreciate any help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Sumproduct and Multiple Data (Daily, Weekly Data)

    Hi JohnMee,

    Is this what you are after?

    Regards

    peterrc
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-03-2014
    Location
    Alberta, Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: Sumproduct and Multiple Data (Daily, Weekly Data)

    Hi Peterrc,

    Thanks for the response however, I was trying to avoid using the average formula. See the scores on Columns D, F, H,J and L were already averaged. I was hoping to get the end of week scores as a weighted average (considering there are difference on the number of audits). Is it still workable in a SUMPRODUCT formula or a different formula (except for AVERAGE)?

    Am I complicating things?

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Sumproduct and Multiple Data (Daily, Weekly Data)

    Hi JohnMee,

    Oops! I got that wrong!

    Version 2 attached, is this what you are after?

    Regards

    peterrc
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-03-2014
    Location
    Alberta, Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: Sumproduct and Multiple Data (Daily, Weekly Data)

    Thanks Peterrc! Perfectly what I'm after.

  6. #6
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Sumproduct and Multiple Data (Daily, Weekly Data)

    Hi JohnMee,

    Thanks for letting me know - don't forget to mark the thread "Solved"

    Regards

    peterrc

+ 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. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  2. Replies: 1
    Last Post: 03-21-2013, 10:45 PM
  3. Replies: 2
    Last Post: 02-03-2012, 02:58 AM
  4. Daily data to weekly data conversion in Excel?
    By dlanc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Daily data to weekly data conversion in Excel?
    By dlanc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1