Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Add condition to formula | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |