Use SumIf and SumIfs Function in Accounts Receivable Status Report

I receive many requests from viewers to help them to create and to analyze “Accounts Receivable Reports.” So, I created this Excel Video tutorial to demonstrate how both the SUMIF and the SUMIFS Functions can help you to analyze the data in an AR Status Report.

The SUMIF() Function has been available for many years in Excel – and it is a great function to use. However, starting in Excel 2007, we now have the expanded SUMIFS Function which allows us to evaluate multiple ranges using multiple criteria to return the sum of our results. This is a terrific improvement!

SUMIFS Function

SUMIFS in Excel 2007

Use SUMIFS() Function

With the SUMIFS Function, you no longer have to create multiple, complicated “nested IF Functions. Rather. you use a series of “paired arguments” – Criteria Range1, Criteria1″ etc. to define the result that you want to return.

So, with the SUMIFS() Function, you can use “paired” Criteria Ranges and Criteria to produce the exact results that you are seeking!

This, alone, may be one of the reasons to upgrade to either Excel 2007 or to Excel 2010!

Watch this Video in High Definition mode on YouTube

Here is the link to view this Excel lesson in High Definition on my YouTube Channel

You can learn how to “Master Excel in Minutes – Not Months!”