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