# How to look up a value in a list and sum multiple corresponding va

S

#### sum multiple corresponding values

i have some products (every product has code) with daily sales
if i want to search for the sum. of sales for 1 product for a day
how can i do it???

ex:
A B C
1 Date Product Sales
2 12/09/2009 001 1000
3 12/09/2009 0031 100
4 12/09/2009 001 200
5 13/09/2009 001 1050
6 13/09/2009 0031 50

now, if i want to sum sales for product 001 at 12/09/2009
what is the formula i can use???

M

#### Mike H

Hi,

Try this

=SUMPRODUCT(--(A2:A15=DATE(2009,9,12))*(B2:B15=31)*(C2:C15))

But those product codes look suspicious to me, are they text? If so try

=SUMPRODUCT(--(A2:A15=DATE(2009,9,12))*(B2:B15="0031")*(C2:C15))

Mike

A

#### Ashish Mathur

Hi,

You can also use a pivot table here. Drag Product and Date to the row area
and sales to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sum multiple corresponding values" <sum multiple corresponding
(e-mail address removed)> wrote in message
news:[email protected]