G
Guest
I want to find a specific total from a combination of numbers on a spreadsheet.
How can i go about this in excel
How can i go about this in excel
S
Susan
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
=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
G
Guest
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?
for a deposit that was made up of different number on the spreadsheet, how
can i find which numbers equals that deposit?
P
Peo Sjoblom
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
it here (look up solver in help)
http://tinyurl.com/pfswm
H
Harlan Grove
....Zima said:
Learn to use Google Groups search.
http://groups.google.com/groups/search?q=find+sum+combination+group:*.excel*&qt_s=Search
Many responses to many people asking the same question, giving several
different approaches.