adding range names

[Guest]

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?

 

[Bob Phillips]

=sum(test,example)

--

HTH

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

 

[Guest]

Try =SUM(test, example)