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 – www.thecompanyrocks.com – 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**

Tags: array formulas, business, CSE Formulas in Excel, data, excel, Formula Error Messages, information, management, mobile device, office, software, Software Tutorial, SUMPRODUCT Function, technology, training, work

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

@todaslasmujeres…

@todaslasmujeres

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