Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!

Possibly Too Many Arguments
 

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!