Multiple conditions

[Muthukrishnan V]

Thank you for resolving my request.
Excel 2007.
Now alternatively, I want to improve the SAME database
with helper cells.
Col C5:C84 contain dates dd-mm-yyyy
Col D5:D84 contain amount in numerical
Col E5:E84 contain dates dd-mm-yyyy
Additions:
In addition to my database in C5:E84 as above, I have added
input in Col G5:G84. G5:G84 contain text either "current" "old" and
some cells blank.
H 101 (helper cell) contains date less than H102 in dd-mm-yyyy (one of the dates in C5:C84);
H 102 (helper cell) contains date greater than H101 in dd-mm-yyyy (one of the dates in C5:C84).
H103 (helper cell) contains a text "Current" (one of the text from G5:G84)
Based on the values in helper cells H 101 to H 103, i want sumproduct of D5:D84.
Kindly help.

 

[Special-K99]

Your description is a little vague

Try

SUMPRODUCT((G5:G84=H103)*(C5:C84>=H101)*(C5:C84<=H102)*(D5:D84))

If it doesnt work swap the < > signs around in the formula.

 

[Muthukrishnan V]

Thank you Sir, Great! It works.