USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=COUNTIF
|
|
|
=COUNT
|
|
|
=COUNTA
|
|
|
=SUM
|
Detailed explanation-1: -The syntax of the COUNTA function is–“COUNTA(value1, [value2], …), ” where “value 1” (mandatory) and “value 2” are the values to be counted. The argument of the COUNTA function can be a range, a cell, a value, an array of values, or a reference to cell ranges.
Detailed explanation-2: -This COUNTA Function works in all the versions of Excel – from Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and even Microsoft Office Excel 365 (the cloud version.) So to count the number of employees, you only need to say =COUNTA(A5:A15).
Detailed explanation-3: -COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). To count unique values, use COUNTUNIQUE . To count only numeric values use COUNT .