No, you would need multiple cells for that as a cell cannot have a value and
a formula, one or the other, not both.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"jamie" wrote in message
...
Hi

In this function, i would like the cell to look at the current year and
month. if this is the current month and year, eg may2006, if true, add up
a
list of names, if false eg mar 2006, keep the total that was counted when
true.

so the funtion needs to save the number counted when true and then keep it
for when the junction is false.

i have tried to do this without success. can anyone help?

thanks