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 10:06 PM. Reason: Need to adjust title
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks