Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits?
Explanation:
The COUNTA function counts all non-empty cells within a range, regardless of whether they contain numbers, text, or errors. The COUNT function counts cells with numbers only.
Explanation:
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.
No comments yet. Be the first to start the discussion!