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: SUMIFSC:C A:A A D:DE Which of the follow is true with regards to this function?
a The function will sum values in the range C:C based on the defined criteria.
b The function will sum values in the range A:A based on the defined criteria.
c The function will sum values in the range D:D based on the defined criteria.
d The output of the function will be an error because the criteria argument, E does not contain a valid logical test.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
