Count Low Stock Items
I need to count how many products have 'Stock Level' < 10 and 'Status' is 'Active'. This helps me prioritize which products need restocking to avoid running out of popular items.
=COUNTIFS(B2:B11,"<10",C2:C11,"Active") How it works: The COUNTIFS function is perfect for this scenario because it allows you to count rows that meet multiple criteria simultaneously. Here, `B2:B11` is the range for 'Stock Level', and `"<10"` is the first criterion, counting items with stock less than 10. `C2:C11` is the range for 'Status', and `"Active"` is the second criterion, ensuring only active products are included. COUNTIFS only counts a row if *all* specified criteria are met, effectively combining them with an 'AND' logic.
Data Setup
| Product Name | Stock Level | Status |
|---|---|---|
| T-Shirt | 5 | Active |
| Mug | 12 | Active |
| Hoodie | 8 | Inactive |
| Hat | 3 | Active |
| Socks | 15 | Inactive |
| Keychain | 9 | Active |
| Poster | 7 | Active |
| Sticker | 10 | Active |
| Backpack | 2 | Active |
| Water Bottle | 11 | Inactive |
Step-by-Step Guide
Open your product inventory spreadsheet in Excel.
Identify the column containing 'Stock Level' (e.g., Column B) and the column containing 'Status' (e.g., Column C).
Select an empty cell where you want the count to appear.
Type the formula: `=COUNTIFS(B2:B11,"<10",C2:C11,"Active")`
Press Enter. The cell will display the total count of active products with stock levels below 10.