An Array Formula can be used to calculate total sales in Excel for an array or range of data. Click here to read our step by step guide!