Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
Adding Range Names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |