# Tag Archives | SUM

## Comparing Single Cell Vs Range As The Reference In The OFFSET Function In Excel

In this tutorial we’ll take a look at the OFFSET function, specifically the difference between using a single cell vs a range of cells for the reference argument, and using it in conjunction with the SUM function.

## How To Create A Dynamic Range Using The OFFSET Function In Excel

In this tutorial we are going to look at two ways of creating a dynamic range of data. We are summing up sales data and want to automatically, or dynamically adjust the range to sum as we incorporate additional rows or columns. One way will be using Tables and the other the OFFSET function. Let’s […]

## How To SUM A Range Of Values In An Array Using INDIRECT, ADDRESS, and MATCH Functions In Excel

In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.

## How To Use The AGGREGATE Function with Hidden Rows and Errors In Excel

The AGGREGATE function in Excel is much more powerful than the SUBTOTAL function with additional built in options and the ability to ignore errors and hidden rows. Let’s see how that works in Excel!

## Two Methods To Calculate The Average Sales Eliminating Outliers in Excel

In this tutorial we are going to look at two ways that you can calculate the average sales of accounts, but eliminating the top 5 and bottom 5 accounts which may distort the overall average.

## How To Lookup Values with INDEX and MATCH Plus Adding Rows or Columns In Excel

You can use the combination of INDEX and MATCH to look up values in an array. But did you know that you can also use this combination in conjunction with the SUM function to total up rows or colums? Here’s how!