Tip 006 - Using SUMIF With Multiple Criteria скачать в хорошем качестве

Tip 006 - Using SUMIF With Multiple Criteria

This Advanced Excel tip from Profitwyse will show you how to utilize multiple criteria when utilizing the SUMIF function. Most Excel users do not know how to create more complex criteria which, when used properly, can expand your application of the SUMIF function. In the video example, we show you how to create a report that performs a SUMIF by department by G/L account (multi dimension SUMIF) 00:00 Introduction 00:35 Explanation of summary solution - YTD spend by cost center for 15 departments 01:15 Explanation of Trial Balance Detail source data and illustration on 1 dimension use of SUMIF 04:15 Expanding the SUMIF example to include 2 dimensions example explained 04:45 Changes to SUMIF to include 2 dimensions (Department & Cost Account Summarized) 06:50 Creating the SUMIF with 2 dimensions and adding in a validation check sum Check out Profitwsye Academy for additional Excel training content that will take your skills to a greater level of success at the following link: Profitwyse Academy: https://bit.ly/3vJnTla