I want to see if someone can help me find a simplied or modified way to
approach a procedure I am doing.

I currently have a spreadsheet that contains 31 worksheets, 1 for each day
in a month. Each worksheet has a column called dept. For each record, the
appropriate dept number is entered. There are ususually between 10-15 depts.
At the end of the month, I need to count how many depts were used throughout
the entire month. I have been physically counting each one by hand. Is there
a better way to accomplish this task without having to waste an entire day of
counting?

Hi Metalteck

You can use the counta function to count cells with something in it
It will count between the first sheet "Sheet1" and last sheet "Sheet31"

=COUNTA(Sheet1:Sheet31!A1)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Metalteck" wrote in message ...
I want to see if someone can help me find a simplied or modified way to
approach a procedure I am doing.

I currently have a spreadsheet that contains 31 worksheets, 1 for each day
in a month. Each worksheet has a column called dept. For each record, the
appropriate dept number is entered. There are ususually between 10-15 depts.
At the end of the month, I need to count how many depts were used throughout
the entire month. I have been physically counting each one by hand. Is there
a better way to accomplish this task without having to waste an entire day of
counting?

Would I write it as =counta('1':'31'!u18)
U18, being the column where I want the information to come from?

"Ron de Bruin" wrote:

Hi Metalteck

You can use the counta function to count cells with something in it
It will count between the first sheet "Sheet1" and last sheet "Sheet31"

=COUNTA(Sheet1:Sheet31!A1)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Metalteck" wrote in message ...
I want to see if someone can help me find a simplied or modified way to
approach a procedure I am doing.

I currently have a spreadsheet that contains 31 worksheets, 1 for each day
in a month. Each worksheet has a column called dept. For each record, the
appropriate dept number is entered. There are ususually between 10-15 depts.
At the end of the month, I need to count how many depts were used throughout
the entire month. I have been physically counting each one by hand. Is there
a better way to accomplish this task without having to waste an entire day of
counting?

Like this

=COUNTA('1:31'!U18)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Metalteck" wrote in message ...
Would I write it as =counta('1':'31'!u18)
U18, being the column where I want the information to come from?

"Ron de Bruin" wrote:

Hi Metalteck

You can use the counta function to count cells with something in it
It will count between the first sheet "Sheet1" and last sheet "Sheet31"

=COUNTA(Sheet1:Sheet31!A1)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Metalteck" wrote in message ...
I want to see if someone can help me find a simplied or modified way to
approach a procedure I am doing.

I currently have a spreadsheet that contains 31 worksheets, 1 for each day
in a month. Each worksheet has a column called dept. For each record, the
appropriate dept number is entered. There are ususually between 10-15 depts.
At the end of the month, I need to count how many depts were used throughout
the entire month. I have been physically counting each one by hand. Is there
a better way to accomplish this task without having to waste an entire day of
counting?