98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Excel intro
microsoft excel training - Excel intro
Resolved · Low Priority · Version Standard
Debbie has attended:
Excel Introduction course
Excel intro
What is the difference between count - countA?
RE: Excel intro
Hi Debbie, Thank you for the post, To answer your question, the difference between COUNT and COUNTA;
COUNT will consider the selected range of cells and return a number which is the number of values in the range. ie just numbers.
COUNTA will consider the selected range of cells and return a number which is the number of values and lables in the range, ie everything. So if the range has headings or labels, COUNT will ignore them, but COUNTA will include them. I hope that helps, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Validating text entries1. Select the range of cells.
where A1 is the first cell in the range. 6. Click OK. |