Summing Total Sales, Based on Quantity & Price



Calculating the total sales price of all the items listed in column A, based on the amount of items sold (column B), and the price per unit (column C).

Solution 1:

Use the SUMPRODUCT function as shown in the following formula:

Solution 2:

Use the SUM function as shown in the following Array formula:

Leave a Reply

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


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>