+ Reply to Thread
Results 1 to 2 of 2

SUMIF Multiple values within Column

  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    MN USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question SUMIF Multiple values within Column

    I'm trying to devise a formula that will pick up a 'values' (quantity sold on each day) within a range; mutliple each 'value' times the retail price; and then sum the total price of each item resulting in total sales for that day.

    E.g.

    ------------------------------------- Quantity Sold
    Item ------- Retail Price ------ 12/11/11 ----- 12/10/11 ----- 12/09/11-----
    Prod X ----- $5 ---- 1 ----- 0 ----- 1-----
    Prod Y ----- $4 ----- 0 ----- 2 ----- 0 -----
    Prod Z ----- $3 ----- 0 ----- 0 ---- 3
    Prod A ----- $10 ----- 1 ----- 1 ----- 1
    Prod B ----- $1 ----- 0 ----- 4 ----- 0
    Prod C ----- $2 ----- 1 ----- 1 ----- 1

    So for the day 12/11/11, I'm looking for a result of $17 = ($5*1+$10*1+$2*1).
    12/10/11 --- $26 ($4*2+$10*2+$1*4+$2*1)

    Please help!

    Thank you.
    Last edited by rstrosch; 12-09-2011 at 11:06 PM. Reason: Need to adjust title

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: SUMIF Multiple values within Column

    Hello
    If your data is in Cells A1:E7 (with headings) for example, then in cell C8 filled across to E8, use the formula:

    =SUMPRODUCT($B$2:$B$7,C$2:C$7)

    This should give the results you're looking for.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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