SUMPRODUCT() results in an error

Originally Posted by daddylonglegs

I'm still not clear what you want to count, that will make a difference to the formula you use. I understand you want to exclude errors.....but do you want to count numbers only.....or text and numbers......or something else?

If the answer is numbers only then I would use COUNT but if you want to use SUMPRODUCT you can use this version

=SUMPRODUCT(--ISNUMBER($A$1:$A$5))

.....but that doesn't include any text values (or logical values) in the count - do you need to include those too?

Yes, I want to count for both numbers and text values.