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?