Previous Topic Next Topic

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.



Related:

1 reply

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))
0
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.
0

Similar discussions

Excel Sum Greater than but Less Than
Ian -
Alli -

4 responses
if sum>= 60, color cells red
mindy -
mindy -

4 responses
Excel Macro to group by column & sum value
Shital -
Pearson24 -

2 responses
C program to print 1 11111 1111
Amrit -
agrajtech17 -

1 response
Sum values from one column if another column equals x
Sarah -
vcoolio -

3 responses
c++ program computing sum of squares of two
kajinti -
don -

1 response