Question: The commands = count ( data range ) and = counta ( data range ) in Excel Neither command is in Excel, they have been
The commands countdata range and countadata range in Excel
Neither command is in Excel, they have been replaced by the command sumrange numberletter
They serve the same purpose, ie do the same thing.
Counta counts the number of cells in the range which has values either a number or letters.
There is no countadata range in Excel.
Count counts the number of cells in the range with a number.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
