How to use SUM function to get specific value

[Feroz90]

Hi Excel Gurus,

Is there any option to add the columns to get particular value.

Lets say for example as below:

500
500
500
500
150
150

Can we able to get only 300 as result by adding this column.

 

[Joe4]

You would typically use Solver to do that.
Here is a tutorial: https://www.youtube.com/watch?v=pBZbhvCqX44
There are many other articles on Solver you can find with a Google search.

 

[Feroz90]

Hi,

Any other option, I need to do that for more than 600 row items.

[TABLE="width: 100"]
<tbody>[TR]
[TD]Days[/TD]
[TD]Amount 1[/TD]
[TD]Amount 2[/TD]
[TD]Amount 3[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500
[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[/TR]
</tbody>[/TABLE]

I need to specifically mention in another column that the Row 3 & 4 get 2000 in Amount 3 and Row 1 & 2 get 1000 in Amount 3

Please assist

 

[Joe4]

Any other option

Not that I know of, but I don't typically deal with these sort of problems.