Merged Cell arithmatic
 

Request help from someone smarter than me!

I have merged cells B3 and C3, B4 and C4, B5 and C5, B6 and C6.
I need to add the values stored in the new B3, B4, B5 and place the sum into
the new B6 cell.

Any suggestions will be greatly appreciated.

William

Merged Cell arithmatic
 

William, am I missing something? =SUM(B3:B5)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"William A. Beard" wrote in message
.. .
Request help from someone smarter than me!

I have merged cells B3 and C3, B4 and C4, B5 and C5, B6 and C6.
I need to add the values stored in the new B3, B4, B5 and place the sum
into
the new B6 cell.

Any suggestions will be greatly appreciated.

William

Merged Cell arithmatic
 

Thanks, Paul
When I initially tried that formula, I must of made a type.
But, you are right. It is that simple.

Thanks again!



"Paul B" wrote in message
...
William, am I missing something? =SUM(B3:B5)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"William A. Beard" wrote in message
.. .
Request help from someone smarter than me!

I have merged cells B3 and C3, B4 and C4, B5 and C5, B6 and C6.
I need to add the values stored in the new B3, B4, B5 and place the sum
into
the new B6 cell.

Any suggestions will be greatly appreciated.

William