adding range names
 

Thanks for the help. I am using Excel XP. I have two ranges. One range is
named test the other range is named example. When I type =sum(test) I get the
accurate total. The same for =sum(example). What I would like to do is add
test+example in the same formula. What makes sense to me is to type
=sum(test+example) but it doesn't work. How can I make this work?

=sum(test,example)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SheriTingle" wrote in message
...
Thanks for the help. I am using Excel XP. I have two ranges. One range is
named test the other range is named example. When I type =sum(test) I get
the
accurate total. The same for =sum(example). What I would like to do is add
test+example in the same formula. What makes sense to me is to type
=sum(test+example) but it doesn't work. How can I make this work?

Try =SUM(test, example)

"SheriTingle" wrote:

Thanks for the help. I am using Excel XP. I have two ranges. One range is
named test the other range is named example. When I type =sum(test) I get the
accurate total. The same for =sum(example). What I would like to do is add
test+example in the same formula. What makes sense to me is to type
=sum(test+example) but it doesn't work. How can I make this work?