How to calculate mean in Excel

How to calculate mean in Excel

Calculating the mean of numbers is one of staples of statistical analysis processes. In this article, we’re going to show you how to calculate mean in Excel using the AVERAGE formula. Syntax =AVERAGE( array of numbers ) Steps Begin by creating the formula...
How to create a multi-level Excel lookup

How to create a multi-level Excel lookup

VLOOKUP, HLOOKUP or their predecessor LOOKUP are Excel’s most famous lookup functions. However, these functions can search a value only in a single dimension, meaning that you can’t search horizontally and vertically. Unfortunately, there are no formulas...
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,    ...