Lessthan or =,Greater than and Sum

Solved/Closed
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020
-
Hello,
I have the following values in Excel 2007: A1(38)B1(26)C1(20)D1(80)E1(75)F1(50)G1(3)
In H1 the formula =IF(AND(A1<=B1,A1>=C1,D1>E1,SUMPRODUCT(F1-G1) but i want the formula to return the value(not FALSE) of F1-G1 when all the conditions are met.



1 reply

Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012

Found the formula:

=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020

Hello,
Thanks for coming back to post the answer.