software

hey

a function i have counts a list of names if the logical test is true,
but if the logical test is false, how would i get it to keep the result
it had from when it was true?

eg. if the month and year is equal to the current month and year,
perform action, if not, keep the result from the true test.

it is column C that has this function in. at the moment, in the false
test, the function looks at the above cell, i know this is wrong.

i have attached an example doc to explain.

thanks

Jamie -------------------------------------------------------------------
|Filename: Book.zip |
|Download: www.excelforum.com/attachment.php?postid=4767 |
-------------------------------------------------------------------

--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487
anyone able to help?--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487
anyone able to help?--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487
anyone able to help?--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487Many contributors are reluctant to open an unknown file - can you try
to describe your problem more fully here, with a copy of the formula
you are using now?

Pete
here is the codeCode:
--------------------
=IF(YEAR(TODAY())=$A$3,IF(MONTH(TODAY())=$B11,COUN TA($A$35:$A$59),0),$C10)
--------------------a3=year
b11=month in number format
a35:a59=list of names

it can depend on month and year this function.--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487I still don't understand what it is you want to do. If you want the
value_when_true to show even if the condition is false, then you don't
need a condition, so you could just have:

=COUNTA($A$35:$A$59)

I'm not sure if this helps.

Pete
unfortunately that does not work. as the list of names changes each
month. so if i did a counta function, the previous months would
change.

eg jan = 6 people
feb = 4 people
mar = 3 people

so when the month and year is current, add the list, if not keep the
total people in the cell from the month when it was true.

does this help?--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487
can anyone else help?--
jay d
------------------------------------------------------------------------
jay d's Profile: www.excelforum.com/member.php...oamp;userid=34487
View this thread: www.excelforum.com/showthread...hreadid=542487