![]() ![]() We'll cover examples of all three scenarios in this lesson. specify multiple criteria for SUMPRODUCT) Finding the total sales for all products, but only include those sales for a specific City and Day (i.e.Finding the total sales for all products, but only include those sales for a specific City (i.e.Finding the total sales for all products, where you have Quantity Sold in one column and Price per Unit in another.Scenarios where SUMPRODUCT is useful include: This lesson shows you how to use SUMPRODUCT to do all this, with just one formula. You can also use SUMPRODUCT with one or multiple criteria, whereby SUMPRODUCT will only operate on rows that meet the criteria you define. ![]() Without the SUMPRODUCT function, you would have to to create a third column or row in which you write a formula to multiply the Quantity by Price for each entry in your data, and then write another formula to find the sum of all of those numbers. Quantity Sold and Price Per Unit) and add the results of each individual calculation together. The SUMPRODUCT function allows you to multiply two columns or rows of numbers together (e.g. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |