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(...
How to find unique values Excel

How to find unique values Excel

Managing and organizing data doesn’t have to be a daily routine. You can automated tasks like finding the outliers in your data. In this article, we’re going to show you how to find unique values Excel. Syntax { =IFERROR(   INDEX( data,     MATCH( 0,    ...
How to highlight empty cells

How to highlight empty cells

It’s often a good idea to highlight empty cells in a data set to help easily identify the outliers. Here, you can find out how to highlight empty cells dynamically using Conditional Formatting. Steps Begin by selecting the data range B3:H10 Open the Conditional...
How to create a time calculator in Excel

How to create a time calculator in Excel

When you need to calculate the difference between a time present day and the next day, calculations can get messed up and you will see lots of # characters. This article shows how to create a time calculator in Excel that can calculate shift time after midnight using...
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(...