Tearing My Hair Out! - SUMPRODUCT trouble!

[I'm rubbish with Excel]

This is starting to drive me insane:

I have the following formula in 9 cells within a column. The formula checks another worksheet (Called "Stats") for month (Column C) and staff name (Column P) against the staff name in the current worksheet next to the formula.

=SUMPRODUCT(('[Redraws XL.xls]Stats'!$P$1:$P$65000=A6)*('[Redraws XL.xls]Stats'!$C$1:$C$65000=$A$1))*('[Redraws XL.xls]Stats'!$D$1:$D$65000='Year Totals'!$A$1)

In other words, this formula is in cell B6, checking "Stats!" for any work done by "Heather Burgis" (in cell A6) in January (in cell A1)

For some bizarre reason, the formula only works on one cell (B10), even though I've dragged the formula down all cells and have the same name in the relevent "A" Column next to it (as a test.)

Does anyone have any idea what I'm doing wrong?

Hope this makes sense.

Thanks in advance.

 

[Brian from Maui]

Just a guess,

=SUMPRODUCT(--('[Redraws XL.xls]Stats'!$P$1:$P$65000=A6),--('[Redraws XL.xls]Stats'!$C$1:$C$65000=$A$1),--('[Redraws XL.xls]Stats'!$D$1:$D$65000='Year Totals'!$A$1))

misplaced parenthesis. That's a lot of rows you're checking!

 

[I'm rubbish with Excel]

You're a genius! ray:

Thanks. You should be called the Brain from Maui!