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

  • Thread starter sum multiple corresponding values
  • Start date

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???
 
Ad

Advertisements

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
 
Ad

Advertisements

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top