isnumber()

[ahmad ali]

Hello,

please find the image below,I don't know what's wrong with my formula? could you help me in this ... thanks

[#2 · Accepted solution]

Hi Ahmad,

To return 2.5 use simply

=SUMPRODUCT(A1:I1)

it ignores all texts. SUMPRODUCT(--ISNUMBER(... returns the number of cells with numbers

[#3]

Thank you so much