Download Files: [ Ссылка ]
Entire page with all Excel Files for All Videos: [ Ссылка ]
Learn about how to create a single cell Array Formula to calculate Total Sales from a Column of Units Sold and a column of Prices (5,000 transactions). See how to use SUMPRODUCT function to calculate the unrounded total, and see how to use the ROUND and SUMPRODUCT function to calculate the rounded total. Learn about the basics of Array Formulas.
