Excel Spreadsheet Functions

  • Thread starter Thread starter Beth
  • Start date Start date
B

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
 
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
 
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.
 
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.
 
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
 
Back
Top