Possibly Too Many Arguments

K

Karen

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!
 
D

David Biddulph

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.
 
K

Karen

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'!F11,'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)
 
M

Mike H

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
 
M

Mike H

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
 
K

Karen

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function says too many nested 1
Keeping cells blank even though formula is input 3
specify non-contiguous cell range as arguments to TTEST() 2
Trying to find additional ranges outside of min, max, and average 2
Multiple arguments 3
Function Has Too Many Arguments 4
Sumif apllying to all sheets in workbook 2
Nested If returns error (too many arguments) 9

Top