Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum if type question?
How would i go about solving the following problem?
Example Table: A1: 10 A2: 15 A3: 20 A4: 5 A5: 39 How can i ask the computer to look through the values and find a group of cells that sum up to a ceratin value so for example using the number 50 it would identify that A1,A2,A3 and A4 add up to 50. How would i go about doing that, this is to solve and try figure out what invoices the customer paid when they send a cheque. Thanks. |
#2
|
|||
|
|||
There's an example here using SOLVER (add in that comes with office/excel)
http://tinyurl.com/4doog Regards, Peo Sjoblom "Dan" wrote: How would i go about solving the following problem? Example Table: A1: 10 A2: 15 A3: 20 A4: 5 A5: 39 How can i ask the computer to look through the values and find a group of cells that sum up to a ceratin value so for example using the number 50 it would identify that A1,A2,A3 and A4 add up to 50. How would i go about doing that, this is to solve and try figure out what invoices the customer paid when they send a cheque. Thanks. |
#3
|
|||
|
|||
Thanks very much, that's perfect!
"Peo Sjoblom" wrote: There's an example here using SOLVER (add in that comes with office/excel) http://tinyurl.com/4doog Regards, Peo Sjoblom "Dan" wrote: How would i go about solving the following problem? Example Table: A1: 10 A2: 15 A3: 20 A4: 5 A5: 39 How can i ask the computer to look through the values and find a group of cells that sum up to a ceratin value so for example using the number 50 it would identify that A1,A2,A3 and A4 add up to 50. How would i go about doing that, this is to solve and try figure out what invoices the customer paid when they send a cheque. Thanks. |
#4
|
|||
|
|||
Thanks for the feedback
-- Regards, Peo Sjoblom "Dan" wrote in message ... Thanks very much, that's perfect! "Peo Sjoblom" wrote: There's an example here using SOLVER (add in that comes with office/excel) http://tinyurl.com/4doog Regards, Peo Sjoblom "Dan" wrote: How would i go about solving the following problem? Example Table: A1: 10 A2: 15 A3: 20 A4: 5 A5: 39 How can i ask the computer to look through the values and find a group of cells that sum up to a ceratin value so for example using the number 50 it would identify that A1,A2,A3 and A4 add up to 50. How would i go about doing that, this is to solve and try figure out what invoices the customer paid when they send a cheque. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Type Question | Excel Worksheet Functions | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |