how to find a special total from a combination of numbers
 

I want to find a specific total from a combination of numbers on a spreadsheet.

How can i go about this in excel

how to find a special total from a combination of numbers
 

for instance (replace with your own cell addresses):

=sum($B$3 + $B$10 + $F$7 + $A$10)

instead of typing the addresses manually, you can enter
=sum(
and then click around with the mouse to the values you want to sum,
adding + in between each mouse click.

:)
susan


On May 7, 10:36 am, Zima wrote:
I want to find a specific total from a combination of numbers on a spreadsheet.

How can i go about this in excel

how to find a special total from a combination of numbers
 

I don't want to sum the numbers i want to find a total (for e.x i am looking
for a deposit that was made up of different number on the spreadsheet, how
can i find which numbers equals that deposit?

"Susan" wrote:

for instance (replace with your own cell addresses):

=sum($B$3 + $B$10 + $F$7 + $A$10)

instead of typing the addresses manually, you can enter
=sum(
and then click around with the mouse to the values you want to sum,
adding + in between each mouse click.

:)
susan


On May 7, 10:36 am, Zima wrote:
I want to find a specific total from a combination of numbers on a spreadsheet.

How can i go about this in excel

how to find a special total from a combination of numbers
 

If your data is not too big you can use the solver add-in, example how to do
it here (look up solver in help)

http://tinyurl.com/pfswm



--
Regards,

Peo Sjoblom


"Zima" wrote in message
...
I don't want to sum the numbers i want to find a total (for e.x i am
looking
for a deposit that was made up of different number on the spreadsheet, how
can i find which numbers equals that deposit?

"Susan" wrote:

for instance (replace with your own cell addresses):

=sum($B$3 + $B$10 + $F$7 + $A$10)

instead of typing the addresses manually, you can enter
=sum(
and then click around with the mouse to the values you want to sum,
adding + in between each mouse click.

:)
susan


On May 7, 10:36 am, Zima wrote:
I want to find a specific total from a combination of numbers on a
spreadsheet.

How can i go about this in excel

how to find a special total from a combination of numbers
 

Zima wrote...
I don't want to sum the numbers i want to find a total (for e.x i am looking
for a deposit that was made up of different number on the spreadsheet, how
can i find which numbers equals that deposit?
....

Learn to use Google Groups search.

http://groups.google.com/groups/sear...&qt_ s=Search

Many responses to many people asking the same question, giving several
different approaches.