Sumproduct Formula Issue

Hey everyone I'm looking to use the sumproduct formula since I'm using excel 2003 to sum up the cells in column F (store variance) by day, month, and year. Here is what I have come up with so far but it does not seem to give me the information I need. Please help with this forumla it will be much appreciated.

Thanks,

Madahtter


=SUMPRODUCT(--(DAY(Data!$J$2:$J$445)=B1),--(TEXT(Data!$H$2:$H$445,"mmm")=$A$2),--(YEAR(Data!$G$2:$G$445)=2012)*SUM(Data!$F$2:$F$445))

This could also be a sumif formula =SUMIF(data!$A:$J,DATE('Error Per Day'!$A$1,MONTH('Error Per Day'!$A2),'Error Per Day'!Q$1),data!$F:$F) but still does not give me what I need please help.

Thanks,

Madhatter

I have solved my problem thanks for the views.

=SUMPRODUCT(--(YEAR(Data!$G$2:$G$445)=2012),--(TEXT(Data!$H$2:$H$445,"mmm")=$A$4),--(DAY(Data!$J$2:$J$445)=B1),Data!$F$2:$F$445)

Madhatter