Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arithmatic functions with date format...angry results | Excel Worksheet Functions | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Text Time Coversion Arithmatic | Excel Discussion (Misc queries) | |||
Arithmatic operation on arrays | Excel Programming |