Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Report

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.

Sincerely,

Danny Rocks
The Company Rocks

Duration : 0:9:22


Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , ,

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , ,

4 Responses to “Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Report”

  1. DannyRocksExcels says:

    Thank you for …
    Thank you for writing to tell me that you like both the audio and video for my lessons. I am always happy to get feedback from my viewers.

    Sincerely,

    Danny Rocks
    The Company Rocks

  2. TheMrScribbler says:

    nice audio and …
    nice audio and video

  3. DannyRocksExcels says:

    @pynkz
    My …

    @pynkz
    My pleasure! Thank you for writing to tell me how much you enjoy my video lessons.

    Sincerely,
    Danny Rocks
    The Company Rocks

  4. pynkz says:

    you are the best! …
    you are the best!
    thank you for posting these videos !!

Leave a Reply