Hi, I have a workbook with the following columns;
- Date (Format: MM/DD/YYY) [column D]
- Sales (Number) [Column G]
- Bidder (String) [this can be a name or Withdrawn] [Column H]

I am trying to get two sums;

1) the first of the total sales in a particular month, i got this with the following formula:
=SUMPRODUCT((MONTH('SH1'!D25:'SH1'!D1375)=6)*(YEAR('SH1'!D25:'SH1'!D1375)=2012)*'SH1'!G25:'SH1'!G1375)

2) The second is where i am having a problem, it keeps on giving the wrong value, this is the formula i used:
=SUMPRODUCT((MONTH('SH1'!D20:'SH1'!D1370)=12)*(YEAR('SH1'!D20:'SH1'!D1370)=2011)*('SH1'!H19:'SH1'!H1369="Withdrawn")*'SH1'!G19:'SH1'!G1369)


thanks in advance for the help

cheers