In this tutorial we will use the AND function along with SUM and MOD in Data Validation to control the distribution of inventory to various locations.
Tag Archives | SUM
In this tutorial we’ll take a look at the ADDRESS function and how to use it to dynamically change the SUM range based on a selection from a Data Validation drop down list. We’ll also incorporate the INDIRECT, ROW, and MATCH functions.
In this tutorial we are going to use a simple but creative way to determine the number of unique items in a list in Excel. We’ll use the SUM and COUNTIF functions in an array formula to accomplish this. We’ll also do it manually using Remove Duplicates as a comparison.
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.
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 […]
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.