Count visible cell and ignore zero number

[muhammad susanto]

hello all,

i need some formula, how to count data with visible cell only and WITHOUT/IGNORE ZERO NUMBER (0)

for example :

row (after filter and visible cell only)	data
1	2
5	0
6	0
12	4
15	1
count	3 (DESIRED RESULT

<tbody>
</tbody>

i tired with subtotal(3,.......) , but not fully working....

COULD YOU HELP ME, TO FIGURE IT OUT??

THANKS FOR YOUR HELPING....


M.SUSANTO

 

[cyrilbrd]

Hi, try =COUNTIF(B2:B6,">=1")

 

[muhammad susanto]

thanks cyrillbrd,..your formula is not fully working..

i mean at first...filter data then highlighted visible cell only and count..

any ideas??

 

[cyrilbrd]

thanks cyrillbrd,..your formula is not fully working..

i mean at first...filter data then highlighted visible cell only and count..

any ideas??

please clarify your objective.
in what sense the formula did not work?
what do you mean by 'filter' and 'highlight visible cells only'?

 

[muhammad susanto]

ADVERTISEMENT

cyrillbrd, I MEANS, ONLY VISIBLE CELL WITHOUT ZERO NUMBER/BLANK MUST BE COUNT IT....

 

[cyrilbrd]

muhammad susanto, capital letters not needed for comprehension.

If you wish to count all visible cell excluding hidden cells and zero kindly consider =COUNT(IF(SUBTOTAL(102,OFFSET(L2,ROW(L2:L6)-ROW(L2),0,1)),IF(L2:L6,L2:L6))) Ctrl + Shift + Enter not just Enter on a PC or Command + Return on a MAC.

 

[muhammad susanto]

ADVERTISEMENT

cyrillbrd, thanks,

i am happy now....

 

[cyrilbrd]

cyrillbrd, thanks,

i am happy now....

Most welcome.
Thanks for the feedback.

 

[muhammad susanto]

cyrillbrd, thanks,

i am happy now....