If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pls help me!!
Hallo there!
Pls refer to the attached file (01) Filename = "Auto Update". How can I have my cell in "yellow" to show TEXT + sum of month automaticlly while I updating the table above (Jan-Dec'04)? For example: Yellow cells (F12:H12) shown "Jan'04 Total = $130.5", I want to see "Feb'04 Total = $???.00" when I start to update any of the cell in Feb'04. What formula should I use to capture these changes in the table? Thank you very much. davidiew --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Pls help me!!
Hi
a formula like this which combines text and references to cell values may be what your after (see grey cells in attached). =TEXT(C2, "mmm yy")&" Total =" & C9 Attachment filename: zqsaaq.xls Download attachment: http://www.excelforum.com/attachment.php?postid=454129 --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|