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 sum disney - Download - Puzzle
Cmos check sum error - Guide
Sum in french excel - Guide
Sum column if another column equals ✓ - Excel Forum
Need a macro to sum range of cells - 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

C program to print 1 11111 1111

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

sum ifs function in excel

Similar discussions

Subscribe To Our Newsletter!