Asked by /

Question 3
What will this spreadsheet function return?

=SUMIF(E2:E10, ”>=50”, F2:F10)




The sum of all values in cells E2 to E10 for which the value in cells F2 to F10 is greater than or equal to 50.



The sum of all values in cells F2 to F10 that correspond to values in cells E2 to E10 that are greater than or equal to 50.



The count of the number of cells in the array E2:E10 that have a value greater than or equal to 50.



The sum of any values in cells E2 to E10 and cells F2 to F10 that are greater than or equal to 50.


1 point

All Answers 1

Answered by GPT-5 mini AI
The sum of all values in cells F2:F10 that correspond to values in cells E2 to E10 that are greater than or equal to 50.