In cell M10 on the "Summer Bookings" worksheet, insert a function that calculates the total amount of sales from the "Total" column for groups containing 12 or more people even if the order of the…

1. In cell M10 on the "Summer Bookings" worksheet, insert the following SUMIF formula: "=SUMIF(I6:I24, ">=12", J6:J24).

Perform operations with formulas and functions

Question

In cell M10 on the "Summer Bookings" worksheet, insert a function that calculates the total amount of sales from the "Total" column for groups containing 12 or more people even if the order of the rows is changed.

Explanation

In cell M10 on the "Summer Bookings" worksheet, insert the following SUMIF formula: "=SUMIF(I6:I24, ">=12", J6:J24).

Topics

#SUMIF#conditional sum#structured references#table functions

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice