Hi,

I am try to auto insert "Text" into all the empty cell A and insert SUM into cell B, here is my spread sheet:
1 Col A ColB ColC
2 Book 1 4/25/07
3 Paper 2 4/27/07
4
5 Pen 1 5/5/07
6 Booka 2 5/15/07
7 Bookb 1 5/21/07
8
9 Papera 1 8/2/07
10 Paperb 1 8/24/07
11

In the ColA cell (1,4) and ColC the month is "4" then I would like to insert "Total 4"
In the ColA cell (1,8) and ColC the month is "5" then I would like to insert "Total 5" and so on....

In the ColB cell (2,4) then I would like to insert "SUM=3" fomular in each empty cell on B.

Any help is very appreciate.
Thanks