MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Wallace Bernard on January 07, 2002 7:37 AM

Making a small sheet for overtime. want to count entrys
I can count letters or numbers, but when I try to use a combo of the two like (10pm-4am) I get no count.

Posted by Michelle on January 07, 2002 7:49 AM

=Count(range) will count numbers only
=Counta(range) will count text or numbers

Try using counta(range)