MrExcel Publishing
Your One Stop for Excel Tips & Solutions

snag


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.
Help
Wally


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)