Question

Differentiate between simple and multiple criteria ?
plz tell me fast because tomorrow is my exam

Answer 1

The SUMPRODUCT function allows you to multiply two columns or rows of numbers together (e.g. Quantity Sold and Price Per Unit) and add the results of each individual calculation together. 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. You can also use SUMPRODUCT with one or multiple criteria, whereby SUMPRODUCT will only operate on rows that meet the criteria you define.

I hope this will help you...