COUNTA Function Archives

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

Nov 28, 2021 Excel Basics

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

Nov 22, 2021 Excel Formulas

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)

Nov 1, 2021 Excel Formulas

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)

Nov 15, 2021 Excel Basics

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)

Nov 2, 2021 Excel Functions 2

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)

Nov 14, 2021 Excel Functions

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)

Nov 16, 2021 Excel Formulas

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)

Nov 15, 2021 Excel Formulas

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

Dec 2, 2021 Excel Formulas

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]

Nov 4, 2021 Excel Formulas

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)

Nov 11, 2021 Excel Formulas

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)

Nov 11, 2021 Excel Formulas

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)

Oct 13, 2021 Excel Formulas

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)

Oct 13, 2021 Excel Formulas

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)

Oct 12, 2021 Excel Formulas

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 ...