software

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

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)

quot;jamiequot; gt; wrote in message
...
gt; Hi
gt;
gt; In this function, i would like the cell to look at the current year and
gt; month. if this is the current month and year, eg may2006, if true, add up
a
gt; list of names, if false eg mar 2006, keep the total that was counted when
gt; true.
gt;
gt; so the funtion needs to save the number counted when true and then keep it
gt; for when the junction is false.
gt;
gt; i have tried to do this without success. can anyone help?
gt;
gt; thanks
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...

quot;Bob Phillipsquot; wrote:

gt; No, you would need multiple cells for that as a cell cannot have a value and
gt; a formula, one or the other, not both.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;jamiequot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; In this function, i would like the cell to look at the current year and
gt; gt; month. if this is the current month and year, eg may2006, if true, add up
gt; a
gt; gt; list of names, if false eg mar 2006, keep the total that was counted when
gt; gt; true.
gt; gt;
gt; gt; so the funtion needs to save the number counted when true and then keep it
gt; gt; for when the junction is false.
gt; gt;
gt; gt; i have tried to do this without success. can anyone help?
gt; gt;
gt; gt; thanks
gt;
gt;
gt;

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)

quot;jamiequot; gt; wrote in message
...
gt; thanks. but isnt that classed as circular?
gt;
gt; eg. cell a1 has the function, the true total is saved to b1, then a1 = b2
gt; if the a1 statement is false...
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; No, you would need multiple cells for that as a cell cannot have a value
and
gt; gt; a formula, one or the other, not both.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;jamiequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; In this function, i would like the cell to look at the current year
and
gt; gt; gt; month. if this is the current month and year, eg may2006, if true,
add up
gt; gt; a
gt; gt; gt; list of names, if false eg mar 2006, keep the total that was counted
when
gt; gt; gt; true.
gt; gt; gt;
gt; gt; gt; so the funtion needs to save the number counted when true and then
keep it
gt; gt; gt; for when the junction is false.
gt; gt; gt;
gt; gt; gt; i have tried to do this without success. can anyone help?
gt; gt; gt;
gt; gt; gt; thanks
gt; gt;
gt; gt;
gt; gt;
Are you saying that you want the formula to show April 2006 until May is
reached and then show May?--
Don Guillett
SalesAid Software

quot;jamiequot; gt; wrote in message
...
gt; Hi
gt;
gt; In this function, i would like the cell to look at the current year and
gt; month. if this is the current month and year, eg may2006, if true, add up
gt; a
gt; list of names, if false eg mar 2006, keep the total that was counted when
gt; true.
gt;
gt; so the funtion needs to save the number counted when true and then keep it
gt; for when the junction is false.
gt;
gt; i have tried to do this without success. can anyone help?
gt;
gt; thanks
no, i mean each month has a serparate cell. when the next month starts, then
the following cell will count up how many names in the list and the previous
month, that cell will keep the amount it had when true.

quot;Don Guillettquot; wrote:

gt; Are you saying that you want the formula to show April 2006 until May is
gt; reached and then show May?
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;jamiequot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; In this function, i would like the cell to look at the current year and
gt; gt; month. if this is the current month and year, eg may2006, if true, add up
gt; gt; a
gt; gt; list of names, if false eg mar 2006, keep the total that was counted when
gt; gt; true.
gt; gt;
gt; gt; so the funtion needs to save the number counted when true and then keep it
gt; gt; for when the junction is false.
gt; gt;
gt; gt; i have tried to do this without success. can anyone help?
gt; gt;
gt; gt; thanks
gt;
gt;
gt;

i am aware each function has a true and false. what do you mean?
quot;Bob Phillipsquot; wrote:

gt; I don't think I fully understand what you are trying to do. Keep an example
gt; of TRUE and an example of FALSE.
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;jamiequot; gt; wrote in message
gt; ...
gt; gt; thanks. but isnt that classed as circular?
gt; gt;
gt; gt; eg. cell a1 has the function, the true total is saved to b1, then a1 = b2
gt; gt; if the a1 statement is false...
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; No, you would need multiple cells for that as a cell cannot have a value
gt; and
gt; gt; gt; a formula, one or the other, not both.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove xxx from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;jamiequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hi
gt; gt; gt; gt;
gt; gt; gt; gt; In this function, i would like the cell to look at the current year
gt; and
gt; gt; gt; gt; month. if this is the current month and year, eg may2006, if true,
gt; add up
gt; gt; gt; a
gt; gt; gt; gt; list of names, if false eg mar 2006, keep the total that was counted
gt; when
gt; gt; gt; gt; true.
gt; gt; gt; gt;
gt; gt; gt; gt; so the funtion needs to save the number counted when true and then
gt; keep it
gt; gt; gt; gt; for when the junction is false.
gt; gt; gt; gt;
gt; gt; gt; gt; i have tried to do this without success. can anyone help?
gt; gt; gt; gt;
gt; gt; gt; gt; thanks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

copy/paste your layout here

--
Don Guillett
SalesAid Software

quot;jamiequot; gt; wrote in message
...
gt; no, i mean each month has a serparate cell. when the next month starts,
gt; then
gt; the following cell will count up how many names in the list and the
gt; previous
gt; month, that cell will keep the amount it had when true.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; Are you saying that you want the formula to show April 2006 until May is
gt;gt; reached and then show May?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;jamiequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi
gt;gt; gt;
gt;gt; gt; In this function, i would like the cell to look at the current year and
gt;gt; gt; month. if this is the current month and year, eg may2006, if true, add
gt;gt; gt; up
gt;gt; gt; a
gt;gt; gt; list of names, if false eg mar 2006, keep the total that was counted
gt;gt; gt; when
gt;gt; gt; true.
gt;gt; gt;
gt;gt; gt; so the funtion needs to save the number counted when true and then keep
gt;gt; gt; it
gt;gt; gt; for when the junction is false.
gt;gt; gt;
gt;gt; gt; i have tried to do this without success. can anyone help?
gt;gt; gt;
gt;gt; gt; thanks
gt;gt;
gt;gt;
gt;gt;
I mean give an example where it does equal current month and year with
required results, and then one where it doesn't.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;jamiequot; gt; wrote in message
...
gt; i am aware each function has a true and false. what do you mean?
gt;
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; I don't think I fully understand what you are trying to do. Keep an
example
gt; gt; of TRUE and an example of FALSE.
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;jamiequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; thanks. but isnt that classed as circular?
gt; gt; gt;
gt; gt; gt; eg. cell a1 has the function, the true total is saved to b1, then a1
= b2
gt; gt; gt; if the a1 statement is false...
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; No, you would need multiple cells for that as a cell cannot have a
value
gt; gt; and
gt; gt; gt; gt; a formula, one or the other, not both.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove xxx from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;jamiequot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Hi
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; In this function, i would like the cell to look at the current
year
gt; gt; and
gt; gt; gt; gt; gt; month. if this is the current month and year, eg may2006, if
true,
gt; gt; add up
gt; gt; gt; gt; a
gt; gt; gt; gt; gt; list of names, if false eg mar 2006, keep the total that was
counted
gt; gt; when
gt; gt; gt; gt; gt; true.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; so the funtion needs to save the number counted when true and then
gt; gt; keep it
gt; gt; gt; gt; gt; for when the junction is false.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; i have tried to do this without success. can anyone help?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; thanks
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
the below is for one of the periods of time. under number of people at the
moment is just example data.

2006
MonthMonthNo. of people
January110
February210
March37
April47
May59
June6
July7
August8
September9
October10
November11
December12quot;Don Guillettquot; wrote:

gt; copy/paste your layout here
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;jamiequot; gt; wrote in message
gt; ...
gt; gt; no, i mean each month has a serparate cell. when the next month starts,
gt; gt; then
gt; gt; the following cell will count up how many names in the list and the
gt; gt; previous
gt; gt; month, that cell will keep the amount it had when true.
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt;gt; Are you saying that you want the formula to show April 2006 until May is
gt; gt;gt; reached and then show May?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;jamiequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi
gt; gt;gt; gt;
gt; gt;gt; gt; In this function, i would like the cell to look at the current year and
gt; gt;gt; gt; month. if this is the current month and year, eg may2006, if true, add
gt; gt;gt; gt; up
gt; gt;gt; gt; a
gt; gt;gt; gt; list of names, if false eg mar 2006, keep the total that was counted
gt; gt;gt; gt; when
gt; gt;gt; gt; true.
gt; gt;gt; gt;
gt; gt;gt; gt; so the funtion needs to save the number counted when true and then keep
gt; gt;gt; gt; it
gt; gt;gt; gt; for when the junction is false.
gt; gt;gt; gt;
gt; gt;gt; gt; i have tried to do this without success. can anyone help?
gt; gt;gt; gt;
gt; gt;gt; gt; thanks
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;