Closed Thread
Results 1 to 8 of 8

Monthly weighted averages

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Monthly weighted averages

    Hello,

    I'm having difficulty with a weighted average calculation. I have a list of dates, trade volumes and prices. My task is to create a weighted average price for these dates by month.

    For example, for August 2012, I have 12 different trades being executed, 9 in July, 4 in June, etc. I'm trying to find a formula to give in this example 3 different weighted average price calculations, 1 for each month. Any suggestions?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Monthly weighted averages

    You get better help if you post an Excel-file (example of your workbook), without confidential information

    i gonna use pivot table for that.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Monthly weighted averages

    How does this post differ to the one you posted yesterday http://www.excelforum.com/excel-form...91#post2909891 and which you acknowledged was solved.

    If it's not solved then remove the 'Solved' marker and post again in the same thread

    Convince me this is not a duplicate or I will need to close it.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    08-24-2012
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Monthly weighted averages

    Same worksheet, different problem. I now have to create a weighted average of each month's trades, and I've been having trouble getting the sumif function to pull data only from a specific month. Can you give any advice on how to do that?

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Monthly weighted averages

    use a helpercollumn

    b4=month(a4)

  6. #6
    Registered User
    Join Date
    08-24-2012
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Monthly weighted averages

    I tried that, with this criteria in the sumif function: and(month=8, year=2012). The function returned 0s.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Monthly weighted averages

    show us the file, without confidentional information.

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Monthly weighted averages

    Hi,

    In my opinion it's not essentially any different to your last post. The answer to that gave you a weighted average per day.
    A weighted average per month is only different by time. The answer given last time can be adjusted to give you the monthly weighted avge. Instead of the SUMIF() formula use SUMIFS() and in the formula instead of a single date, specify a start and end date.

    The standard response follows....

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    ---------- Post added at 11:22 PM ---------- Previous post was at 11:20 PM ----------

    @oeldere

    Please don't respond to a post whilst there is still an outstanding question by a moderator. With 1000+ posts you really should know that.

Closed Thread

Thread Information

Users Browsing this Thread

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

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