3.3 COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS
| Function | Counts | Example | Result |
|---|---|---|---|
| COUNT | Cells with numbers | =COUNT(G2:G11) |
10 |
| COUNTA | Non-empty cells (any type) | =COUNTA(A2:A11) |
10 |
| COUNTBLANK | Empty cells | =COUNTBLANK(A2:I11) |
0 |
| COUNTIF | Cells meeting one condition | =COUNTIF(C2:C11,"Pune") |
4 |
| COUNTIFS | Rows meeting all conditions | =COUNTIFS(D2:D11,"Blinkit",I2:I11,"Delivered") |
5 |
More examples: late deliveries =COUNTIF(H2:H11,">15") → 3; orders in any city starting with "Na" (Nashik, Nagpur) =COUNTIF(C2:C11,"Na*") → 3.
Steps in Excel – delivery performance table
- K10
Delivered:=COUNTIF(I2:I11,"Delivered")→ 7. - K11
Cancelled:=COUNTIF(I2:I11,"Cancelled")→ 2. - K12
Cancellation %:=K11/COUNTA(A2:A11)→ 20%.
Ravindra Bagale's Tip
COUNT fakt numbers mojto – khup students Order ID (text) var COUNT lavtat aani 0 yeto. Text sathi COUNTA vapra. Ani COUNTA la space asleli "rikami distnari" cell pan bharleli vatate, mhanun kadhi kadhi count jast yeto – aadhi data clean kara (Module 5).
Practice task
Count: orders per platform, orders in Pune that took ≤ 10 minutes, and blank cells in the Status column of the full Orders sheet.