sum row to find value equal to or less than Cell (B1)

[elsg]

Hi.
I have several values ​​in row 2. (B2. G2 .....)
In "B3" I have the value (Stock), which I will use to compare with row 2.
In "B1" will be the result


what I need is:
How to know if the sum of line 2 is equal to or less than "B3"


In my example form 4 cells to arrive at an approximate value of "B3" (10 + 15 + 10 + 10 = 45)

Result	4
SumRow	10	15	10	10	20	15
Stock	50

<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[jamtay317]

=if(sum(b2:g2)<=b3,sum(b2:g2),"")

 

[Robert Mika]

Like this?

Excel Workbook
	A	B	C	D	E	F	G	H
1	Result	4
2	SumRow	10	15	10	10	20	15
3	Stock	50
4
5	yes
Sheet1

 

[Aladin Akyurek]

See:

Name the MrExcel Logo - Answer to Challenge of the Month

 

[elsg]

Hello, Robert


the result should be in "B1"
and would be the value 4


Hello, jamtay317
I do not understand what you did.

 

[jamtay317]

did the fourmula not work?

 

[Aladin Akyurek]

Hello, Robert


the result should be in "B1"
and would be the value 4


Hello, jamtay317
I do not understand what you did.

Are you wanting the sum of a combination that satisfies or wondering which consecutive values from B on sums to the condition specified?

If the latter, control+shift+enter, not just enter:

=MATCH(B3,SUBTOTAL(9,OFFSET(B2,0,0,1,COLUMN(B2:G2)-COLUMN(B2)+1)),1)

 

[jamtay317]

Hello, Robert


the result should be in "B1"
and would be the value 4


Hello, jamtay317
I do not understand what you did.

I think that you could use =if(sum(b2:g2)<=b3,sum(b2:g2),"There is enough stock")

 

[elsg]

Hi
i want the sum of a combination that satisfies

how many cells the formula should sum to be less than or equal to "B1".

 

[jamtay317]

what is the range that your trying to add?