Watch, as I use both the SUMIF and the (new) SUMIFS functions to analyze an Accounts Receivable Status Report.
With the SumIf Function in Excel, you only sum the cells in a range that match the condition that you set. Using this function is much easier than writing an equivalent IF() Function.
Starting in Excel 2007, we can use the new SUMIFS() Function to total only those cell values that match multiple conditions. As you will see, the arguments for SUMIFS are “in pairs” – Criteria Range1 and Criteria1, etc.
SUMIFS is a very powerful function. Having it available is one major reason to upgrade to either Excel 2007 or to Excel 2010.
I invite you to visit my online shopping website – http://shop.thecompanyrocks.com – to see all of my videos and to preview the many resources and services that I offer.
The Company Rocks
Duration : 0:9:22
Tags: analysis, business, computer software, computers, data, economic, Educational, excel functions, finance, financial, Help, how to, information, instructions, management, Microsoft Excel, New in Excel 2007, office, programs, software, Software Tutorial, SUMIFS Function, Systems, technology, tips, training, tutorial