Asked in BCG and 4 others
What is the difference between the COUNT() and COUNTA() functions in Excel?
AnswerBot
1y
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: CO...read more
Anonymous
1y
Many diffrant between count counta count farmula count only number and counta farmula count number and text both
Help your peers!
Add answer anonymously...
Interview Questions from Popular Companies
3.7
• 8.7k Interviews
4.0
• 5.4k Interviews
3.5
• 4.2k Interviews
3.6
• 8k Interviews
3.7
• 6k Interviews
3.7
• 6.2k Interviews
3.5
• 4.2k Interviews
3.7
• 5.1k Interviews
Stay ahead in your career. Get AmbitionBox app
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
