Are you saying that you want the formula to show April 2006 until May is
reached and then show May?


--
Don Guillett
SalesAid Software

"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