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.
Tag Archives | SUMIFS
In this tutorial we will look at how we can use VLOOKUP with multiple criteria, but with the special twist that the choice of one criteria can come from different columns!
Let’s compare these three ways of creating a summary chart from our raw sales data to see which is more preferable…..
Here is one method to sum up a variety of columns based on dymanic data validation lists and using SUMIFS, CHOOSE, and MATCH functions…..
Here is a follow up post based on a question I received on my previous post about SUMIF & SUMIFS…..
Here are the differences and similarities in using the SUMIF & SUMIFS functions in Excel…..