Excel Spreadsheet Functions

[Beth]

Hello:

I would like to select the value of a cell (cell contains COUNT function)
and copy to another sheet at the end of each month so that I have a specific
count for the month and do this for the entire year.

Can I use a function for this or do I need a macro? I was trying to use the
IF function but couldn't get what I was looking for.

Thanks

 

[Bernard Liengme]

You question does not give enough info
What is the formula?
What does the data look like that you want to count?
Please give us more so we can help

 

[Shane Devenshire]

Hi,

Can't use a function to do this. If the count formula is always the same
cell on the first sheet you will need a macro.

Of course you could do it the manual way copy, move to the second sheet and
choose Edit, Paste Special, Values.

 

[Beth]

Hello:

I am counting the number of people in a list and I have 7 sheets with 7
counts =Count(A2:A10). Each list is ongoing and the count changes as more
people are added to the lists. I would like to capture the count each month
(at the end of the month) on a summary sheet that shows the count by month
for the entire year.

I would like this to be done automatically instead of cut and paste due to
the number of sheets.

So the summary sheet looks like:

Jan Feb Mar Apr
List 1 10 20 15 22
List 2 5 14 13 20
and so on
I hope this is enough information.

 

[Bernard Liengme]

Do you mean something like this:
In each sheet there is the formula =Count(A2:A10), let's say it is in cell
B1
On the summary sheet use =Sheet!B1, =Sheet2!B1 etc
OR to get the total in one go =SUM(Sheet1:Sheet7!B1)
best wishes