sumproduct producing #VALUE!

"Bob Phillips" wrote
> That's okay for text Max, but won't work with an error result.

Yes, you're right. Thanks. Should have tested more thoroughly
Looks like we've to go the array route (similar to Aladin's 2nd formula):
=SUM(IF((Table1!J2:J5='Summary Results
PC'!B$13)*(ISNUMBER((Table1!N2:N5))),Table1!N2:N5))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

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
----

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