Count Unsold Listings
I need to count items where 'Days Listed' > 30 and 'Bids' = 0.
=COUNTIFS(B2:B7, ">30", C2:C7, "=0") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this scenario, it checks two conditions simultaneously: 1. `B2:B7, ">30"`: This criterion checks the 'Days Listed' column (B2 to B7) and counts only those items where the number of days listed is greater than 30. 2. `C2:C7, "=0"`: This criterion then checks the 'Bids' column (C2 to C7) and counts only those items that have exactly 0 bids. Only items that satisfy *both* conditions (more than 30 days listed AND 0 bids) are included in the final count, providing a precise number of potentially stale, unsold listings.
Data Setup
| Item ID | Days Listed | Bids | Listing Status |
|---|---|---|---|
| EB001 | 45 | 0 | Active |
| EB002 | 20 | 1 | Active |
| EB003 | 35 | 2 | Active |
| EB004 | 50 | 0 | Active |
| EB005 | 15 | 0 | Active |
| EB006 | 60 | 0 | Active |
Step-by-Step Guide
Organize your eBay listing data with columns for 'Item ID', 'Days Listed', 'Bids', and 'Listing Status'.
Identify the range containing 'Days Listed' (e.g., B2:B7).
Identify the range containing 'Bids' (e.g., C2:C7).
In an empty cell, enter the COUNTIFS formula: `=COUNTIFS(B2:B7, ">30", C2:C7, "=0")`
Press Enter to get the total count of listings that have been active for more than 30 days with zero bids.