| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel find a sequence of numbers from a known total? | Excel Discussion (Misc queries) | |||
| find numbers in a list which sum a total | Excel Worksheet Functions | |||
| Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions | |||
| Total a Combination of Numbers | Excel Worksheet Functions | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Linear Mode
