Hi,

I have the following data:

Excel Data 2.JPG

What I need to is be able to count the number of cells in each column with numbers only. For example C10:C13 should equal 1 and F10:F13 should total 0. I currently am using the following formula to ignore the #n/a cells: =SUM(IF(ISERROR(C10:C13),"",C10:C13))

It does however count blank cells which I do not want it to do.

Any help is much appreciated.

Thanks,

Drew.