Next, you will determine if there is a significant difference between the average amount spent at the spa and the average amount spent at the spa for non-spa (Null) members. To gather this information, you will need to create a formula based on two sets of criteria.

In cell C4, enter a function to calculate the average if the guest stayed at least 4 nights and is a non-spa (Null) customer.