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?
1 answers ( 0 marked as helpful)
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.
Submit an answer
Resolved: How did you select all the table rows and columns in one click?
How can I easily select a column from entire dataset to place in PivotTable Area?
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error