Entry totals

**John Gross** · 11-15-2013, 02:57 PM

Is there a way to track # of entries in a column? I don't care the amount or type of entry. I just want to know a total of entries.

**alansidman** · 11-15-2013, 03:29 PM

Counta function will count the number of non-blank cells in a range.

http://www.techonthenet.com/excel/formulas/counta.php

**kurtis.fafard** · 11-15-2013, 03:43 PM

you could also just select the column/row in question. It will tell you the Average, Count and Sum of the column.
excel count.jpg

**John Gross** · 11-15-2013, 04:11 PM

Originally Posted by John Gross

Is there a way to track # of entries in a column? I don't care the amount or type of entry. I just want to know a total of entries.

Thank you that does it

**John Gross** · 11-15-2013, 04:11 PM

Thank you --that does it

**alansidman** · 11-15-2013, 04:32 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: Entry totals