Hi


SUMPRODUCT(--(TEXT(Sheet!A1:A10,"yyyy.mm")="2006.01"),--(Sheet!B1:B10=Sheet1!C1:C10),Sheet1B1:B10)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Aaron Saulisberry" wrote in
message ...
I'm currently using the formula below to breake it down by month but I
also
need to have it breakdown those months by year.

SUMPRODUCT(--(MONTH(Sheet!A1:A10)=1),--(Sheet!B1:B10=Sheet1!C1:C10),Sheet1B1:B10)

This formula compares two columns and if those columns have the same data
for the same month then it returns the sum of the data. The only problem
is
is does not distingush between year, which I need it to do so.

Any help is appreciated.

1-JAN-05