I need help with a formula!
 

Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!

SGT,

in cell B6, array enter (enter using Ctrl-Shift-Enter) the formula

=SUM(VALUE(LEFT(B4:B5,FIND(":",B4:B5)-1)))&":"&SUM(VALUE(MID(B4:B5,FIND(":",B4:B5)+1,15) ))

All that should be on one line. Then copy and paste to C6.

HTH,
Bernie
MS Excel MVP

"SGT Banuelos" <SGT wrote in message
...
Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!

Ordinarily, Excel applies the same format to the cell with the SUM formula as
the cells being summed. What is happening in your case?


On Tue, 16 Nov 2004 17:33:02 -0800, SGT Banuelos <SGT
wrote:

Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!