SOLVED
Home

isnumber()

Highlighted
ahmad ali
Contributor

Hello,

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

2 Replies
Highlighted
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

 

 

Highlighted

Thank you so much