All of the following statements are TRUE about the SUMIF and SUMIFS functions EXCEPT:
A)The SUMIF and SUMIFS functions select values from a range of data based on criteria, and then add those values.
B)SUMIF functions are based on one criterion.
C)The SUMIF and SUMIFS arguments are very dissimilar.
D)The SUMIFS function allows for more than one filtering criteria.

Question

Quizplus · Accepted Answer

The statements in A, B, and D are all true about the SUMIF and SUMIFS functions. However, statement C is false as the arguments for the SUMIF and SUMIFS functions are quite similar. The only difference is that SUMIFS allows for multiple criteria, but the structure of the function is otherwise the same as SUMIF.

All of the Following Statements Are TRUE About the SUMIF