COUNT and COUNTA functions in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a retail store.

📋 Request: Your manager wants to know how many sales transactions had numeric quantities sold and how many transactions had any data recorded in the quantity column.

📊 Data: You have a list of sales transactions with the quantity sold in one column. Some entries are numbers, some are text notes, and some cells are empty.

🎯 Deliverable: Create formulas to count how many transactions have numbers in the quantity column and how many have any data at all.

Sample Data

Transaction ID	Quantity Sold
1001	5
1002	3
1003	Returned
1004
1005	2
1006	Out of stock
1007	7
1008
1009	1
1010	Damaged

1

Step 1: Select a cell to count how many transactions have numeric quantities sold.

=COUNT(B2:B11)

Expected Result

5

2

Step 2: Select another cell to count how many transactions have any data recorded in the Quantity Sold column, including text and numbers.

=COUNTA(B2:B11)

Expected Result

8

Final Result

Transaction ID | Quantity Sold
-----------------------------
1001           | 5
1002           | 3
1003           | Returned
1004           | 
1005           | 2
1006           | Out of stock
1007           | 7
1008           | 
1009           | 1
1010           | Damaged

COUNT(B2:B11) result: 5
COUNTA(B2:B11) result: 8

✓There are 5 transactions with numeric quantities sold.

✓There are 8 transactions with any data recorded in the Quantity Sold column.

Bonus Challenge

Create a formula to count how many transactions have text entries (non-numeric) in the Quantity Sold column.

Show Hint

Use COUNTA to count all entries and subtract COUNT which counts only numbers.