ExcelNSG

Home
Basic
- Excel Format Painter – An Introductory Guide
- How to Create a Custom AutoFill List in Excel 2013
Function
VBA
- Copy and Paste in Excel VBA: 4 Easiest Way (For Beginners)
Excel Quiz
- Shortcut Skills
Contact Us
Privacy Policy

Excel COUNTA Function – How to Use (with example)

Leave a Comment / Function / By Narendra Singh

In this blog post, we will learn about Excel COUNTA function. This function is a member of COUNT family of Microsoft Excel. Explanation In simple words, Excel COUNTA function counts every cell value which is not blank. This function counts each non-blank cell value as “1” and skips blanks. In the previous blog post, we …

Excel COUNTA Function – How to Use (with example) Read More »

Excel COUNT Function – How to Use (with example)

Leave a Comment / Function / By Narendra Singh

Excel COUNT function is a very basic and built-in function of excel COUNT family. This function counts only numeric values and skips the text ones. Suppose that we want to make a count of a range (B2: B6) i.e. (1, 5, 7, a, b) and apply COUNT function =COUNT (B2: B6) and our result is …

Excel COUNT Function – How to Use (with example) Read More »