Respuesta :

Answer:

On cell G16, type the formula "=SUMIF(G2:G11, ">=40")".

Explanation:

Formulas in Microsoft Excel are used to generate results or values to a cell. The formula must start with an equal sign. The formula above has the function "SUMIF" which is used to provide a sum of numeric values based on a condition.

fichoh

The SUMIF function in excel combines a condition and a sum of the values which meets the stated condition. Hence, the SUMIF statement required on Cell A17 would be =SUMIF(C1:C50, '>=40')

  • The sumif syntax goes thus ; SUMIF(row_range, condition)

  • Assume the total membership count is in the cell A1 to A50.

  • Cells where the values are greater than or equal to 40 should be summed.

Hence, the required formula would be =SUMIF(C1:C50, '>=40')

Learn more : https://brainly.com/question/17130932

Otras preguntas