SUMPRODUCT Function

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

SUMPRODUCT Multiple Criteria Lookup

Once you are familiar with Excel, one thing may come to your mind often, how you can use the SUMPRODUCT function with multiple criteria. In this ...

SUMPRODUCT with INDEX and MATCH Functions in Excel

In MS Excel, there is a huge diversity of using SUMPRODUCT with INDEX and MATCH functions together. In this article, I’ll try to illustrate how we ...

SUMIF with Multiple Criteria in Column & Row in Excel (Both OR and AND Type)

Today I will be showing how you can calculate the sum in any row or column matching multiple criteria using the SUMIFS() function in Excel. ...

Sum Multiple Columns Based on Multiple Criteria

You may need to calculate the sum of multiple columns. Once you know the methods it will seem as easy as you like. The agenda for today is showing ...

Sum Based on Column and Row Criteria in Excel (7 Handy Ways)

There is a wide range of suitable methods to sum up a range of cells based on column and row criteria in MS Excel. In this article, I’ll try to ...

How to SUMIF by Month in Excel (With Alternative Options)

Today I will be showing how you can sum data by month using SUMIF() and SUMIFS() functions in Microsoft Excel. Download Practice Workbook ...

SUMIF Multiple Criteria Different Columns

Different circumstances may demand the calculation of the sum of cells using multiple criteria. Today, we will show you calculate the sum using the ...

COUNTIF Multiple Ranges Same Criteria in Excel

Sometimes we may need to work with multiple ranges on the same criteria in terms of searching, counting, or sorting. In this way, MS Excel helps us ...

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

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

COUNTIF with Multiple Criteria in Different Columns in Excel (Both Single and Multiple Criteria)

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

How to Count Date Occurrences in Excel

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

ExcelDemy
Logo