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