Firstly, the -- in your formula is redundant.

Secondly, it looks as though you have a formula returning an error result in
the data.

--
__________________________________
HTH

Bob

"Brooks W." wrote in message
...
I am using the following formula to check for 2 criteria

=SUMPRODUCT(--('Intl Detail'!A2:A737=10950796)*('Intl
Detail'!W2:W737="Y"))

This gives me the correct count for the information I have.

However, on a new spreadsheet (this is on a monthly report we get) I get
the
#VALUE message for this formula

=SUMPRODUCT(--('Intl Detail'!A2:A898=10950796)*('Intl
Detail'!W2:W898="Y"))

The only difference is the range specified.

This happens on my office machine as well as my home machine. Both are
using
Excel 2003.
--
Brooks W.