Tag: SumProduct
Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
Friday Challenge – Advanced Excel Summation Skills
This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will find...
How-to Make a Music Festival Schedule Using Excel Conditional Formatting
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts.
However, he originally created the...
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge.
Here was the original Challenge:
friday-challenge-pipeline-usage-chart
Here was...
