Latest Posts

Excel Count Visible Rows (Formula and VBA Code)

To satisfy the demand of different circumstances you may need to count only the visible rows in Excel. Today we will show you how to count visible ...

COUNTIF between Two Cell Values in Excel (5 Examples)

In MS-Excel there are several functions purposed for counting different kinds of cells, such as blanks or non-blanks, with a number, date, or text ...

How to Use COUNTIF to Count Cells Greater Than 0 in Excel

COUNTIF function is one of the most basic & simple operations in MS Excel that can be used to count 0(Zero), greater than 0 or less than 0 under ...

Excel Formula to Count Days from Date to Today (8 Effective Ways)

Counting the number of days in Excel is a significant task in our day-to-day activities. But what are the Excel formulas to do that in an efficient ...

Count Unique Values with Criteria by SUMPRODUCT in Excel

In MS Excel, the SUMPRODUCT function provides plenty of complex calculations from the arrays which can be used to count unique values under single or ...

How Do I Count Cells with Text in Excel

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

COUNTIF Function in Different Columns with Multiple Criteria in Excel

Today I will be showing how you can count cells in different columns with multiple criteria in Microsoft Excel using COUNTIF function. Download ...

Excel 2 Decimal Places without Rounding (4 Efficient Ways)

Sometimes we may need to get values up to two decimal places. There are several ways to do that. In this article, I will show how to get two decimal ...

Excel Round to Nearest 100 (6 Quickest Ways)

In certain circumstances, we prefer the rounded or the approximate number rather than the exact number for making communication easier. For example, ...

How to Match Multiple Criteria from Different Arrays in Excel

Finding cells that satisfy multiple criteria from different arrays is a typical task in Excel. There are many ways to accomplish this task. In this ...

How to Count the Number of Occurrences in a Date Range in Excel

Today I will show how you can count the number occurrences of a particular day in a range of dates and also the total number of days in a particular ...

Excel Count Number of Occurrences of Each Value in a Column

For performing different tasks in Excel you may need to count the occurrence number of each value. Agenda for this article is to show you how to ...

COUNTIF with Multiple Criteria in Different Columns in Excel

Microsoft Excel has provided very useful & common functions named COUNTIF & COUNTIFS to count cells under multiple criteria in different ...

Excel round to nearest 10000 (5 Easiest Ways)

Rounding is necessary when we deal with numbers. In Excel, we can easily round numbers to any specific value using different functions. In this ...

How to Split One Cell into Two in Excel (5 Useful Methods)

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

ExcelDemy
Logo