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

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.

Lessthan or =,Greater than and Sum
Sum in french excel - Guide
Sum sum disney - Download - Puzzle
Cmos check sum error - Guide
Md5 sum windows - Guide
Excel sum column if another column equals ✓ - Excel Forum

1 response

Answer 1 / 1

Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012
Aug 16, 2010 at 04:39 AM

Found the formula:

=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))

jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020
Aug 16, 2010 at 07:04 AM

Hello,
Thanks for coming back to post the answer.

Similar discussions

Excel Sum Greater than but Less Than

c++ program computing sum of squares of two

How Sum the Column value in Excel via VBA based on criteria?

SUM IFS function

Sum on hack my id

Similar discussions

Subscribe To Our Newsletter!