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 counts only numbers – many students use COUNT on Order ID (text) and get 0. Use COUNTA for text. Also, COUNTA treats a cell that "looks empty" but contains a space as filled, so sometimes the count comes out higher – clean the data first (Module 5).
Ravindra Bagale's Tip – मराठी
COUNT फक्त numbers मोजतो – बरेच students Order ID (text) वर COUNT लावतात आणि 0 येतो. Text साठी COUNTA वापरा. आणि COUNTA ला space असलेली "रिकामी दिसणारी" cell पण भरलेली वाटते, म्हणून कधी कधी count जास्त येतो – आधी data clean करा (Module 5).
Ravindra Bagale's Tip – हिंदी
COUNT सिर्फ़ numbers गिनता है – बहुत से students Order ID (text) पर COUNT लगाते हैं और 0 आता है. Text के लिए COUNTA इस्तेमाल करो. और COUNTA को space वाली "खाली दिखने वाली" cell भी भरी हुई लगती है, इसलिए कभी-कभी count ज़्यादा आता है – पहले data clean करो (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.