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
How to sum days in excel - Guide
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
Cmos check sum error - Guide
Md5 sum windows - Guide

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

Why sum of some numbers is 0

Sum values from one column if another column equals x

sum certain cells in a column if corresponding cells of another

Sum on hack my id

How do I not get the sum of a column when it contains text?

Similar discussions

Subscribe To Our Newsletter!