MS Excel Array Formulas and Functions Part 2


In this second screen cast on Array Formulas I take you through using an Array formula inside a sum function to provide a degree of and – or logic to the formulas. I also show how to use a data list to make your spreadsheet dynamic and eaisly show just the data you or your users want to see.

Leave a Reply

Your email address will not be published. Required fields are marked *