Sheets AcademySheets Academy
Premium
Task #86

Memberships by month

A gym is comparing membership sales over the summer. Column A has the purchase dates.

  1. In C2:C15, show the month number of each purchase.
  2. In F2:F4, count how many memberships were sold in each month from E2:E4. Write the formula in F2 and drag it down to F4.
Task #86
Memberships by month

A gym is comparing membership sales over the summer. Column A has the purchase dates.

  1. In C2:C15, show the month number of each purchase.
  2. In F2:F4, count how many memberships were sold in each month from E2:E4. Write the formula in F2 and drag it down to F4.