Count Function
It does not stop here. We are going to learn COUNTA, COUNTBLANK, COUNTIF functions also after this.
Count Function actually counts the cells which contains number or date.
Key Rules to Remember
- It only counts numbers, dates, or formulas that result in numbers.
- It ignores empty cells, text, and logical values like TRUE or FALSE
- If you need to cound based on a specific rule (like counting how many sales were over a certain amount), use COUNTIF
- If you need to count text or non-empty cells, use COUNTA
Common Real Life Uses
- Tracking Sales and Orders: Counting how many order ID numbers or transaction amounts were logged in a daily ledger
- HR and Attendance: Finding the total number of days an employee clocked hours or received a numeric performance metric
- Inventory Audits: Tallying how many stock items have a recorded numeric quantity left in the warehouse
- Financial Auditing: Checking a column of invoice numbers or payment values to ensure no cells are missing entries
So now, I expect, you hit that "SUBSCRIBE" option on our Youtube channel. This will boost my confidence and encourage me to make more videos.
Download Handwritten Notes for Free from our website and use it with fulll responsibility.
Youtube Videos Playlist for Beginners
Day 1: Introduction to Excel (Theoretical) https://youtu.be/6VKwuwv45hU
Day 2: Introduction to Excel (Practical) https://youtu.be/h0mY2wNih6w
Day 3: Getting Familiar with Excel https://youtu.be/ZCxoS9OvnMI
Day 4: Copy Paste Print and Number Series https://youtu.be/_2G1KYxbOLY
Day 5: Important and Regular Shortcuts https://youtu.be/KiBOyWGQQNE
Read our articles and download notes
Day 3: Getting Familiar with Excel
Happy Learning.
Signing Off.......
0 Comments