In Excel, which function calculates the total of a range but ignores error values?
A. SUMPRODUCT
B. SUMIF
C. AGGREGATE
D. SUM
Answer: Option C
Solution (By JKSSB Mock Tests)
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
No comments yet. Be the first to start the discussion!