In cell M9 on the "Summer Bookings" worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.

Explanation/Reference: Explanation: 1. In cell M9, on the "Summer Bookings" worksheet, insert the following COUNTIF formula: "=COUNTIF(G8:G24,">=12")"

Perform operations with formulas and functions

Question

In cell M9 on the "Summer Bookings" worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.

Explanation

Explanation/Reference: Explanation: 1. In cell M9, on the "Summer Bookings" worksheet, insert the following COUNTIF formula: "=COUNTIF(G8:G24,">=12")"

Topics

#COUNTIF#conditional count#structured references#table functions

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice