Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555

Download Excel File: https://ift.tt/2xnQEFg
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video learn how to create a Sales Team Total Sales Formula in two ways: DSUM Function or SUMPRODUCT and SUMIFS. This video is to help celebrate Andrea’s 1000 Excel Video!!! Here is Andreas Thehos YouTube Channel: https://www.youtube.com/user/AThehos
DSUM with a Criteria area set up to do an OR Logical Test.
SUMIFS and SUMPRODUCT to perform adding on an Array Calculation. See a Function Argument Array Operation in the criteria 1 argument in the SUMIFS Function.

Topics:
1. (00:01) Introduction
2. (00:23) DSUM Method
3. (02:22) SUMPRODUCT & SUMIFS Method
4. (03:21) Summary

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.