summing issue
 

hello everyone,
i have a question.
I have a column of numbers say 30, 15, 25,17
I want to tell excel to find the cells whose sums add up to a certain total
say 32
( which would in my case be 15 and 17)
How would i write that as a formula?
Thank you

summing issue
 

try this answer:

http://groups.google.com/group/micro...3c842d362f7 b

"john quinn" wrote:

hello everyone,
i have a question.
I have a column of numbers say 30, 15, 25,17
I want to tell excel to find the cells whose sums add up to a certain total
say 32
( which would in my case be 15 and 17)
How would i write that as a formula?
Thank you

summing issue
 

thanks nikki

it works

"Nikki" wrote:

try this answer:

http://groups.google.com/group/micro...3c842d362f7 b

"john quinn" wrote:

hello everyone,
i have a question.
I have a column of numbers say 30, 15, 25,17
I want to tell excel to find the cells whose sums add up to a certain total
say 32
( which would in my case be 15 and 17)
How would i write that as a formula?
Thank you