SUMPRODUCT Function is used to sum a range when multiple conditions are met..
The first argument of sumproduct is the range which is to be summed.
Suppose you want to get a sum of a product range which falls between two Dates, In other words, the value in the amount range is summed only if both of the following criteria are met:
First condition: The Product should be Samsung..
Second condition: The range of the Date should be between 1-Jan-2001 & 22-Jan-2001
Here in this example my data is in Range A1:C38 & the conditions to be met are in E1:F3.
The below image is an extract from the worksheet.
The formula I have derived to get the solution is as follows:
=SUMPRODUCT((A2:A38>=F1)*(A2:A38<=F2)*(B2:B38=F3),C2:C38)
Put this formula and you will get the answer. This worksheet demonstrates summing based on multiple criteria. Download Sample File
This is a short and easy tip for time being, see you soon again. "HAPPY LEARNING"
No comments:
Post a Comment