Question: What will this spreadsheet function return? = SUMIF ( H 1 :H 5 0 , > = 5 0 , J 1 :J 5 0

What will this spreadsheet function return?
=SUMIF(H1:H50,>=50, J1:J50)
1 point
The sum of any values in cells H1 to H50and cells J1 to J50 that are greater than or equal to 50.
The sum of all values in cells H1 to H50 for which the value in cells J1 to J50 is greater than or equal to 50.
The sum of all values in cells J1 to J50 that correspond to values in cells H1 to H50 that are greater than or equal to 50.
The count of the number of cells in the array H1:H50 that have a value greater than or equal to 50.

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 Databases Questions!