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.