Forum Discussion
isnumber()
Hello,
please find the image below,I don't know what's wrong with my formula? could you help me in this ... thanks
Hi Ahmad,
To return 2.5 use simply
=SUMPRODUCT(A1:I1)
it ignores all texts. SUMPRODUCT(--ISNUMBER(... returns the number of cells with numbers
Hi Ahmad,
To return 2.5 use simply
=SUMPRODUCT(A1:I1)
it ignores all texts. SUMPRODUCT(--ISNUMBER(... returns the number of cells with numbers
Thank you so much
