How to Work with Array Formulas in Excel

With an Array Formula, you can frequently create formulas quicker because you can eliminate several intermediate calculations.

I begin my introduction to Array Formulas by showing you how to use the SUMPRODUCT Function. Next, I show you two examples of Array Formulas in Excel. I also show you how an Array Formula provides a level of protection for your formulas, because you cannot edit a single cell in the array – you must select the entire range of cells that contain the array formula to edit it or to delete it.

Please visit my website – – to view all of my video lessons and to learn about the services and resources that I offer.

Danny Rocks
The Company Rocks

Duration : 0:7:45

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

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

2 Responses to “How to Work with Array Formulas in Excel”

  1. todaslasmujeres says:

    i learned 3 things …
    i learned 3 things from this video, thank you.

  2. DannyRocksExcels says:


    Thank you for sending me your comment. I am pleased that you were able to learn 3 things from my tutorial.

    Danny Rocks
    The Company Rocks

Leave a Reply