With reference to exercise given ... I wanted to know what difference it makes when we use COUNTA(J:J) ? Is it same as COUNTA(J2:J51) ? By selecting whole column does COUNTA function count the header as well?

Hey Swarntam, COUNTA counts all non-empty cells in a range (text, numbers, etc.). If you use the function for a range which spans across the entire column J, then it will count all non-empty cells in J. If, on the other hand, you apply the COUNTA function on a range from J2 to J51 - it will count the non-empty cells in that cell range only. Best, Ned

Follow this topic

Swarntam Saurav

Last answered:

23 Feb 2022

Posted on:

20 Feb 2022

How to select whole column starting from A2 or A3?

in Introduction to Excel / Key Excel Functions: Count, Counta, Countif, Countifs

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

23 Feb 2022

How to select whole column starting from A2 or A3?

Submit an answer

related questions