SUMPRODUCT Function Archives - Page 11 of 13

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

Apr 5, 2022 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 ...

SUMPRODUCT Multiple Criteria Lookup in Excel

Dec 23, 2021 Excel Formulas

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

Nov 3, 2021 Excel Formulas 3

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)

Feb 16, 2022 Excel Formulas

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 in Excel

May 10, 2022 Excel Formulas

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)

Nov 15, 2021 Excel Formulas

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)

Nov 4, 2021 Excel Formulas 1

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 in Excel (3 Approaches)

Feb 24, 2022 Excel Formulas

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

Oct 14, 2021 Excel Formulas 1

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)

Feb 27, 2022 Excel Formulas

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)

Mar 3, 2022 Excel Formulas

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

Feb 24, 2022 Excel Formulas

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)

Jun 21, 2022 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 ...

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

Apr 11, 2022 Excel Formulas

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

Feb 24, 2022 Excel Formulas

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