count if cells contains a number

[hluk]

hello!

found this thread and I want to do the same but using the countif function...

http://www.excelforum.com/excel-prog...-a-number.html

is there a way to adapt the non-vba if statement and place into the below code?

Please Login or Register  to view this content.

Thank you so much!

[Søren Larsen]

So, you want a non-VBA solution? In that case:

I don't if you can use =COUNTIF(), but the following should work:

=SUMPRODUCT((ISNUM(X:X)*1)

[daddylonglegs]

I'm assuming you want a count of cells in a range which contain any digits, If so try this

=SUMPRODUCT((MMULT(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},Your_range))+0,{1;1;1;1;1;1;1;1;1;1})>0)+0)

[hluk]

I'm assuming you want a count of cells in a range which contain any digits, If so try this

=SUMPRODUCT((MMULT(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},Your_range))+0,{1;1;1;1;1;1;1;1;1;1})>0)+0)

works perfectly. +1 rep.