I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has all
of these stats. I tried calculating all this data and I'm getting and error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

Karen,

If there was a recurring pattern to the cells you want to average it would
be relatively simple but I can't see any pattern at all.

So you still need a solution and here's how I'd do it. I would use a
'Helper' worksheet or an unused part of an existing worksheet and create
formula to pull these values into a contiguous range and would then average
that range.

For example

=SUM('1'!F4:F8,'1'!F11)
Takes care of the first part of your formula

Hope this helps.

Mike

"Karen" wrote:

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

Karen,

I just noticed that you are collecting diferent number of cells from each
sheet so the approach i suggested wont work. Instead yoo can bring each cell
back to a contiguous range on the same sheet e.g.

='1'!f4
='1'!f5
='1'!f6

etc

and then average that range

Mike

"Mike H" wrote:

Karen,

If there was a recurring pattern to the cells you want to average it would
be relatively simple but I can't see any pattern at all.

So you still need a solution and here's how I'd do it. I would use a
'Helper' worksheet or an unused part of an existing worksheet and create
formula to pull these values into a contiguous range and would then average
that range.

For example

=SUM('1'!F4:F8,'1'!F11)
Takes care of the first part of your formula

Hope this helps.

Mike

"Karen" wrote:

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

Thank you! That's a good idea.
So, am I using too many arguments? Is there a limit?
Karen

"Mike H" wrote:

Karen,

If there was a recurring pattern to the cells you want to average it would
be relatively simple but I can't see any pattern at all.

So you still need a solution and here's how I'd do it. I would use a
'Helper' worksheet or an unused part of an existing worksheet and create
formula to pull these values into a contiguous range and would then average
that range.

For example

=SUM('1'!F4:F8,'1'!F11)
Takes care of the first part of your formula

Hope this helps.

Mike

"Karen" wrote:

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

yes 30

mike

"Karen" wrote:

Thank you! That's a good idea.
So, am I using too many arguments? Is there a limit?
Karen

"Mike H" wrote:

Karen,

If there was a recurring pattern to the cells you want to average it would
be relatively simple but I can't see any pattern at all.

So you still need a solution and here's how I'd do it. I would use a
'Helper' worksheet or an unused part of an existing worksheet and create
formula to pull these values into a contiguous range and would then average
that range.

For example

=SUM('1'!F4:F8,'1'!F11)
Takes care of the first part of your formula

Hope this helps.

Mike

"Karen" wrote:

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!

Thank you!

"Mike H" wrote:

yes 30

mike

"Karen" wrote:

Thank you! That's a good idea.
So, am I using too many arguments? Is there a limit?
Karen

"Mike H" wrote:

Karen,

If there was a recurring pattern to the cells you want to average it would
be relatively simple but I can't see any pattern at all.

So you still need a solution and here's how I'd do it. I would use a
'Helper' worksheet or an unused part of an existing worksheet and create
formula to pull these values into a contiguous range and would then average
that range.

For example

=SUM('1'!F4:F8,'1'!F11)
Takes care of the first part of your formula

Hope this helps.

Mike

"Karen" wrote:

Thank you for your help David.
=AVERAGE('1'!F4:F8,'1'!F11,'3'!F4:F6,'3'!F8:F11,'4 '!F4,'5'!F4:F7,'6'!F4:F5,'7'!F4:F6,'8'!F4:F7,'8'!F 11,'10'!F4:F10,'10'!F12,'11'!F4,'12'!F4:F6,'13'!F4 :F5,'14'!F4:F6,'15'!F4:F7,'15'!F10,'17'!F4:F8,'17' !F11,'18'!F4,'19'!F4:F7,'20'!F4:F5,'21'!F4:F6,'22' !F4:F9,'22'!F11,'24'!F4:F9,'24'!F11,'26'!F4:F6,'27 '!F4:F5,'28'!F4:F5,'29'!F4:F9,'29'!F11,'31'!F4:F8, '31'!F11)


"David Biddulph" wrote:

If you show us the formula which you are trying to use, we might be able to
help.
Don't try to retype it; copy it from your formula bar and paste here.
--
David Biddulph

"Karen" wrote in message
...
I have 31 sheet tabs that I have to sum, average and find the minimum &
maximum of 100 cells of data. I want to create a separate sheet that has
all
of these stats. I tried calculating all this data and I'm getting and
error
message:

The formula you typed contains an error:
1. For more information about fixing common problems, click help.
2. To get assistance in entering a function, click OK then click function
on
the Insert menu.
3. If you are not trying to enter a formula, avoid using an equal sign or
minus sign or precede it with a single quotation.

Are there too many cells of data? Am I trying to calculate too many
arguments? HELP!