On Mon, 11 Feb 2008 05:17:02 -0800, GD wrote:

Thanks Ron, i've amended it to be relevant to my sheets..

=SUMPRODUCT((MONTH('2008 Errors'!A3:A3000)=1)*('2008
Errors'!P3:P3000="KT")*'2008 Errors'!Q3:Q3000)

as it's referring to another sheets cells, and unfortunately it's returning
a result of #VALUE!

Any ideas?

Most likely, your data is not in the expected format. If all of the values in
col Q are numeric, then I'll guess there's an issue with your DATE column where
one or more entries are not "real Excel dates".

You can probably sort this out by, on your 2008 Errors worksheet, take an
unused column and, in row 3, enter =month(a3). Fill down to a3000 and see if
any of the cells return a #VALUE!.


--ron