Sum the cells value of every row that belong to a specific criterion

[Triben]

Hi there,

I am over-thinking it. I am sure it is simple but I can't get it alone, need help.

Here is the thing:

I have a spreadsheet listing revenue for specific products.
Every single line is a revenue "event" and on this line one cell will contain the date.

I want in another tab of the file to compile things for clear monitoring.

I would like to have a chart likeExample.xlsx:
product a brought $XXX on July 2012 $ZZZZ on August 2012
prodcut b brought $YYYYon July 2012 $WWW on August 2012

and so on...

I know how to get the income generated for one type of product (with sumif)

But I cannot find a way to get the income generated for one product on a specific month.

An example file is attached for you to understand my gibberish.

Thanks guys

[benishiryo]

hi Triben. not sure what you mean when you say $XXX on July 2012 $ZZZZ on August 2012. if you meant on Aug 2012 for both, try this in I4:
=SUMPRODUCT(($A$2:$A$27=$H4)*(TEXT($B$2:$B$27,"myyy")=TEXT(I$3,"myyy")),($C$2:$C$27))

copy down & across. adjust range if necessary to accommodate more data. if i'm wrong, do show your desired results manually keyed in

[SDCh]

Or try this :
column I4, copy down & accross

Please Login or Register  to view this content.

[Triben]

Thank you very much to you both, works great!