Thanks Ron, you were right on...it worked. Kudos!

"Ron Coderre" wrote:

Have you tried the COUNTA function?:
Example:
=COUNTA(A1:B20)

It returns the count of all non-blank cells in the referenced range.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Linda" wrote:

I do not want zeros to just show up when nothing has been put in a cell. But
I want 0's to show up when entered in to the cell. Then I want to count all
whether it is a number or text. Is there any way to count all in a group of
columns to get just the count?