i am aware each function has a true and false. what do you mean?



"Bob Phillips" wrote:

I don't think I fully understand what you are trying to do. Keep an example
of TRUE and an example of FALSE.
--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"jamie" wrote in message
...
thanks. but isnt that classed as circular?

eg. cell a1 has the function, the true total is saved to b1, then a1 = b2
if the a1 statement is false...

"Bob Phillips" wrote:

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