I need help with a formula!

[SGT Banuelos]

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!

 

[Bernie Deitrick]

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

 

[Myrna Larson]

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