Count number of cells with numbers ignoring both #n/a and blanks

**drewsta** · 12-04-2014, 05:37 AM

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.

**Sam Capricci** · 12-04-2014, 06:09 AM

and another duplicate post of http://www.excelforum.com/excel-gene...n-a-cells.html

**Fotis1991** · 12-04-2014, 06:22 AM

Thanks Sambo kid.

unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.