Question: The following SUMIFS function was entered into a cell in an Excel workbook: = SUMIFS ( C 5 :C 1 5 , A 5 :A

The following SUMIFS function was entered into a cell in an Excel workbook: =SUMIFS(C5:C15, A5:A15, A6, D5:D15,"13E2") Which of the follow is true with regards to this function?
a. The function will sum values in the range C5:C15 based on the defined criteria.
b. The function will sum values in the range A5:A15 based on the defined criteria.
c. The function will sum values in the range D5:D15 based on the defined criteria.
d. The output of the function will be an error because the criteria2 argument, ">E2" does not contain a valid logical test.
The following SUMIFS function was entered into a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!