Counting cells question.

[kris.small]

So i just spent 45 mins looking throught the boards for a post earlier and to my suprise nothing that really helped me so time to post i think.

I have 3 columns of times. DAY| NIGHT| Swing| all which will have military time put in under it depending if the activity fell in that time zone (manual input)

i need a formula to calculate how many DAY, NIGHT and Swing entrees there are, basiclly i want to calculate if there is ANY thing inputted into the cell count the cell.

i tried using wildcards but didn't work
=countif($N$6:$N500, "**:**")

but it doesn't work... but something along those lines...
any ideas?

 

[anandvarma]

Try this

=sumproduct(--($n$6:$n$500<>""))

 

[MrRajKumar]

If it is valid time, you can simply use

=COUNT($N$6:$N500)

If you want to avoid zero values, use

=COUNTIF($N$6:$N500,">0")

 

[kris.small]

problem solved thank you!