ExcelBanter - Formula to select values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to select values (https://www.excelbanter.com/excel-discussion-misc-queries/217912-formula-select-values.html)

Emece

Formula to select values

I have a column with different numbers, I want a formula that picks values
from that column in order to sum a number which I specify.

Example:

A
1 10
2 20
3 30
4 50

If I specify 40 in another cell, the formula should pick the values in A1
and A3: 10 and 30.

Thanks in advance

Regards,
Emece.-

Gary''s Student

Formula to select values

http://www.tushar-mehta.com/excel/te...olver_Template
--
Gary''s Student - gsnu200829

"Emece" wrote:

I have a column with different numbers, I want a formula that picks values
from that column in order to sum a number which I specify.

Example:

A
1 10
2 20
3 30
4 50

If I specify 40 in another cell, the formula should pick the values in A1
and A3: 10 and 30.

Thanks in advance

Regards,
Emece.-

All times are GMT +1. The time now is 05:53 AM.