I sent a suggestion workbook to use dates in col and names in col b and use
sumproduct to count the names.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Based on the workbook you sent I really think you need a way to identify
when you put in the names. Then you could use a sumif or sumproduct
formula to identify the number of names for that month.

Or, are you saying that you start over with a complete list of names each
month? This is all you have to count with no other identification for each
name
si
marc
dave
hannah

If so, just change the formula to a value, manually or with a macro


--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
I still don't understand what answer you want. Give a complete example of
the desired result.

--
Don Guillett
SalesAid Software

"jamie" wrote in message
...
the below is for one of the periods of time. under number of people at
the
moment is just example data.

2006
Month Month No. of people
January 1 10
February 2 10
March 3 7
April 4 7
May 5 9
June 6
July 7
August 8
September 9
October 10
November 11
December 12


"Don Guillett" wrote:

copy/paste your layout here

--
Don Guillett
SalesAid Software

"jamie" wrote in message
...
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.

"Don Guillett" wrote:

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