I need to count number of cells with numbers ignoring blanks & #n/a cells

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

Hi,

I have the following data:

Attachment 362791

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:08 AM

this appears to be a duplicate post of this one… http://www.excelforum.com/excel-gene...n-a-cells.html

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

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.