microsoft excel training - excel intro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Excel intro

microsoft excel training - Excel intro

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:

=IsText (A1)

where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips


Server loaded in 0.11 secs.