Results 1 to 3 of 3

SUMPRODUCT if between dates

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2020
    Location
    Houston
    MS-Off Ver
    ??
    Posts
    2

    SUMPRODUCT if between dates

    I'm having trouble with using sumproduct on values between certain dates in order to give a weighted average price.

    I have a column of dates (Column A), a column of volumes Column B), and a column of prices (Column C). I need to find the sumproduct of the volumes and prices between the specified dates in order to calculate a weighted average price. Right now, all I can do is take the sum product of the entire volumes and price columns and simply add in the volumes I want get the W.A.P. on and delete the volumes I no longer need. I would like to have all of the volumes on there and use sumproduct between certain dates so I can get multiples W.A.Ps at once without having to add them in manually one by one.

    All of the examples I have seen on here only seem to deal with two total columns so any help with this would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SumProduct between two dates
    By Hudas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2014, 10:13 AM
  2. Help with SUMPRODUCT between two dates
    By steiom in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-03-2013, 04:44 PM
  3. Excel 2007 : Using SUMPRODUCT with dates???
    By Turbo68 in forum Excel General
    Replies: 5
    Last Post: 01-14-2011, 11:42 AM
  4. Sumproduct and dates
    By Wzbell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2006, 06:33 PM
  5. [SOLVED] sumproduct with dates
    By Bumblebee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2006, 03:20 PM
  6. [SOLVED] sumproduct between two dates
    By in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  7. sumproduct between two dates
    By chased in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Tags for this Thread

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