Lessthan or =,Greater than and Sum
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Aug 13, 2010 at 06:21 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 16, 2010 at 07:04 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 16, 2010 at 07:04 AM
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.
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.
Related:
- Lessthan or =,Greater than and Sum
- Sum in french excel - Guide
- Sum sum disney - Download - Puzzle
- Cmos check sum error - Guide
- Sum on hack my id - Gmail Forum
- Why sum of some numbers is 0 - Excel Forum
1 response
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Aug 16, 2010 at 04:39 AM
Aug 16, 2010 at 04:39 AM
Found the formula:
=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))
=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))
Aug 16, 2010 at 07:04 AM
Thanks for coming back to post the answer.