sumproduct producing #VALUE!

many thanks for all your help, in the end i used:
=SUMPRODUCT((TABLE1!$J$2:$J$2000=$B$45)*(TABLE1!$V$2:$V$2000="n")*(ISNUMBER((TABLE1!$N$2:$N$2000))),TABLE1!$N$2:$N$2000)

(note i have increased the range sizes and criteria)

as it turned out, what i thought were na errors, was actually text
inputted by the user.

Thanks again

Glad to hear that !
Thanks for feeding back to us ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

Glad to hear that !
Thanks for feeding back to us ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----