Count text cells
Exercise 6 of 11 Premium
How many months are listed in column A? Your formula has to count text, not numbers.
Checking your plan…
coffee-shop-sales.xlsx
ABC
1MonthCoffeePastries
2
3
4
5
6
7
8
About basics & math in Excel
Start here if you're new to Excel formulas. These exercises teach you how cell references and ranges work, and how to add up, average, count and round numbers with SUM, AVERAGE, MAX, COUNT and ROUND.
Functions you can use here
SUM(number1, [number2], …)AVERAGE(number1, [number2], …)MAX(number1, [number2], …)COUNT(value1, [value2], …)ROUND(number, num_digits)
More basics & math exercises
- 1.Total revenue
- 2.Average order size
- 3.Largest orderPremium
- 4.Smallest orderPremium
- 5.Count the ordersPremium
- 6.Count text cellsPremium
- 7.Add two cellsPremium
- 8.Revenue per unitPremium
- 9.Percentage changePremium
- 10.Round to the nearest 10Premium
- 11.Share of the totalPremium