Pls help me!!

  • Thread starter Thread starter davidiew
  • Start date Start date
D

davidiew

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 mont
automaticlly while I updating the table above (Jan-Dec'04)?

For example: Yellow cells (F12:H12) shown "Jan'04 Total = $130.5",
want to see "Feb'04 Total = $???.00" when I start to update any of th
cell in Feb'04.

What formula should I use to capture these changes in the table?

Thank you very much.
davidie
 
Hi David,
thanks for your message
assuming that
a) all the cells in your table will be filled in in chronologica
order, and
b) zero values are filled in for the appropriate month,
then you can write a formula that changes automatically as you full i
ned columns, by counting the number of non-blanks cells in a row i
your table, and using this to calculate the offset from the far left o
the table eg formula


=TEXT(OFFSET(A2,0,COUNT(B3:M3)), "mmm yy")&" Total =$"
OFFSET(A9,0,COUNT(B3:M3))

see cell B13 in the attache

Attachment filename: zqsaaq.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45415
 
Back
Top