Function: SUMPRODUCT

Function: SUMPRODUCT

The SUMPRODUCT Excel formula is a Math & Trig function that multiplies the values in arrays, and returns the sum of products. Although this sounds like something you could do using a combination of the SUM and the PRODUCT formulas, there is more to it! Thanks to...
What does double minus — do in Excel

What does double minus — do in Excel

The double minus, also known as double unary, is an operation to convert Boolean values into ones and zeroes. Simply; TRUE to one (1) and FALSE to zero (0). A unary operation is an operation with only one operand, which is in contrast to binary operations that use two...
How to create a year-by-year summation calculator

How to create a year-by-year summation calculator

Although the AVERAGEIF and AVERAGEIFS function can sum values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to create a year-by-year summation calculator with help of...
How to count cells in Excel by year

How to count cells in Excel by year

Although the COUNTIF and COUNTIFS functions can count values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to count cells in Excel by year. Syntax =SUMPRODUCT( N( YEAR(...
Count unique values Excel

Count unique values Excel

This article shows how to count unique values Excel formulas SUMPRODUCT and COUNTIF. The SUMPRODUCT function can handle arrays without actually using array formulas, and this allows evaluating the formulas in each cell of an array. Syntax =SUMPRODUCT( 1 / COUNTIF(...
How to sum by date in Excel without time

How to sum by date in Excel without time

Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However; they can’t work if you have date-time values combined. This article shows How to sum by date in Excel without time using SUMPRODUCT and INT functions. Syntax...
Case Sensitive Count

Case Sensitive Count

Case sensitive count can not be handled easily using standard count formulas like COUNTIF or COUNTIFS. In this article, we’ll shot you how you can count case sensitive data by using a combination of SUMPRODUCT and EXACT functions. Syntax...