Counting (not Null and not Zero)

**Robert_Brownsons** · 09-17-2012, 01:27 PM

Hello Everyone

I would like to ask, I have 1 column and 9 rows (cells), how I can count the number of cells in the column excluding "zero values" and "null cells".

I have attached an example.

I also found a similar post (by our friend Jay, which can be seen below) but I am not experienced so much with logical algorithms so if you could aid me I would be glad.

http://www.excelforum.com/excel-gene...ls-2007-a.html

Thank you very much.

**daddylonglegs** · 09-17-2012, 01:30 PM

Try using COUNTIF to count values > 0

=COUNTIF(B2:B10,">0")

**MarkinTX** · 09-17-2012, 01:34 PM

=COUNTIF(B2:B10,">0")

<--------Please Click the star if this has helped you!!

**MarkinTX** · 09-17-2012, 01:35 PM

I didnt see someone had answered it.

**faisal.alissa** · 09-25-2012, 06:15 AM

hi all;
i have one column and 5 rows (cells) type text, how I can count the number of cells in the column ??
A1=FA
A2=MR
A3=FA
A4=FA
A5=MR
i put the formula in cell A6
=COUNTIF(A1:A5,"FA")
i dont have any result in A6 just show the formula
please advice me

**Richard Buttrey** · 09-25-2012, 06:35 AM

@faisal.alissa
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.