How do i Analysis a range of cells to c which cells sum to a total i have

[Dubbie]

Hi,

I am trying to evlauate a range of figure to cee which ones add up to give
me a total

figures total
10 50
20
30


for example, what fx function will tell me that if you add 20+30 you will
get 50....

 

[Niek Otten]

A popular question; you can find many answers (and problems) in Google Group
Search.
Here's a link to one:

http://groups.google.com/[email protected]&rnum=5


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

-----Original Message-----
Hi,

I am trying to evlauate a range of figure to cee which ones add up to give
me a total

figures total
10 50
20
30


for example, what fx function will tell me that if you add 20+30 you will
get 50....

=sum( cell1,cell2 etc.)
.