counting cells with an integer in

M

Max

Re: counting cells with an integer in

Assuming source numbers in A1:A10
then perhaps, in say, B1:
=SUMPRODUCT(--ISNUMBER(SEARCH(".",A1:A10)))
 
M

Max

Oops, correction. It should be:
=SUMPRODUCT((NOT(ISNUMBER(SEARCH(".",A1:A10)))*(A1:A10<>"")))
 
Top