Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

ResolvedVersion 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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.