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.

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.

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.

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.