How to select whole column starting from A2 or A3?
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?
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.