If you are happy to do this manually:
Type 1 in an empty cell;
Copy that cell
Select the column of Years_of_Experience
Use Edit | Paste Special - Add
Now you can delete the 1 in the first cell
Add a Note (using Drawing toolbar) to remind yourself how to do this each
Jan 1.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"sarahmiller15" wrote in message
...
I am actually trying to figure out the same thing. I have a column for
Years
of Experience and I want it to add 1 every year.

"Lawrence" wrote:

OK, this is probably an easy one, but I can't figure it out. We (two of
us)
keep a list of patients that we put PICCs in, I want to have a small
table
automatically total the number Attempts, not attempts, and successful
placements.
so basically, if D3=Y and E3=LR then add one to the number in Attempts
(J4)
and successful placements (J6).