Get the Dates in a Month?

[andsoiwas]

Hello, can you help get the dates (without the duplicates) and some sums in this sample table for each month?

Example:

May	21	101	102
May	28	101	105
June	01	100	102
June	01	104	102
June	05	103	102
June	06	102	102

I would like to get a result like this in another worksheet:

JUNE	X	Y
01	204	204
05	103	102
06	102	102

How can I get the reds by using only 1 formula for all of them?

Thanks.

[shg]

See Help for the SUMIFS function.

[andsoiwas]

Thanks, what I only know is I can do that for the those in blue, but my main problem is how to get those in red?
(please see my newly edited table)

[Teethless mama]

See the attached

[andsoiwas]

Thanks! I'll keep this thread open for a few days just in case there are other methods our fellow members might be able to think of.

[Ace_XL]

How about pivot tables..

See attached

A bit of reading too..
www.cpearson.com/excel/pivots.htm