COUNTA Function

How to Name a Range in Excel (5 Easy Tricks)

In Microsoft Excel, there are several methods to name a range and make it also dynamic simultaneously. The named ranges are easy to prepare. They are ...

How to Create Dynamic Dependent Drop Down List in Excel

Today I will be showing how you can create a dynamic dependent drop down list in Excel using both Formulas and Tables. What is a Dynamic ...

Random Sort in Excel (Formulas + VBA)

MS Excel provides a few different sorting choices on top of the usual ascending and descending orders. We also have sorted by color or icon, as well ...

Generate Random Number from List in Excel (4 Ways)

Although there is no suitable or single function to extract a random number from a list in Excel, there are numerous ways to manually construct the ...

How to Use SEQUENCE Function in Excel (16 Examples)

In Microsoft Excel, the SEQUENCE function is used to generate a sequence of numeric values in different formats. In this article, you'll learn how ...

How to Use COUNTA Function in Excel (3 Suitable Examples)

In Microsoft Excel, the COUNTA function is generally used to count the cells containing the non-empty character(s) only. In this article, you’ll get ...

How to Use ROW Function in Excel (With 8 Examples)

When you have a tiny dataset, it’s easy to find the row number but in the case of a larger dataset, you may have to use the ROW function. In this ...

Excel Dynamic Named Range Based on Cell Value (5 Easy Ways)

When we need to work with a continuously changing data set, this may need to make our named range dynamic so that it automatically increases to ...

OFFSET Function to Create & Use Dynamic Range in Excel

Dynamic range in Microsoft Excel is commonly used to store a wide range of data by applying the OFFSET function. This stored data with a defined name ...

How to Calculate YTD (Year-to-Date) in Excel [8 simple ways]

Microsoft Excel has provided a wide range of solutions to calculate YTD(Year-to-Date) under different criteria. In this article, you’ll be able to ...

How Do I Count Cells with Text in Excel (5 Methods)

You need to count how many cells contain text within your data set for many different operations. Today we will show you how to count cells with text ...

Excel Formula Count Unique Values (3 Easy Ways)

Working with a large dataset in Excel, you may often need to know how many duplicate and unique values are there. You are definitely not going to ...

Count Cells That Are Not Blank in Excel (6 Useful Methods)

Sometimes for better visualization or any other reasons, your workbook may have blank cells. But in the calculation process or monitoring data, you ...

Excel Formula to Count Cells with Text (Download Free Workbook)

Microsoft Excel provides a wide range of useful functions & methods to count cells with text or any other characters & strings. In this ...

Excel Auto Generate Number Sequence (5 Simple Ways)

Serializing a lot of elements manually in Excel is boring. To get rid of this monotonous issue, I’m going to show you how to generate a number ...

ExcelDemy
Logo