Select Page

## Excel MOD Function

The Excel MOD function is a Math and Trigonometry formula which calculates and returns the remainder after the number is divided by the divisor. This is called a modulo operation. This operation sees frequent use in math problems and building a model, and you can use...

## Function: N

The N function is an information function that returns a value converted to a number. In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods. Supported versions All versions Syntax N(value) Arguments...

## 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 average 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 average calculator with help of the...

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

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

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

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

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