Average for 31 arguments

[Mayte]

Hi -
I'm doing an average that pulls from 31 different sheets in the same book. I
can do the average for 30 sheets ok but when i add sheet 31, I get a message
that I have too many arguments ... any ideas how to come aroudn this? any
help will be greatly appreciate it!!

Cheers,
Mayte

 

[NBVC]

Are you always averaging the same cell from each sheet?

If yes,

Then

=AVERAGE(Sheet1:Sheet31!A1)

should work, where A1 is the cell you are averaging from sheets named
Sheet1 to sheet named Sheet31

 

[RagDyeR]

You might post your actual formula.

If you're using *different* cells on each sheet, you could simply enclose
the Average() formula in double parenthesis:

=Average((arg1,arg2,arg3, ... arg31))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi -
I'm doing an average that pulls from 31 different sheets in the same book. I
can do the average for 30 sheets ok but when i add sheet 31, I get a message
that I have too many arguments ... any ideas how to come aroudn this? any
help will be greatly appreciate it!!

Cheers,
Mayte

 

[Mayte]

yes

 

[Mayte]

I tried the double parenthesis but got "#VALUE!" as the result ..??

=AVERAGE(('July 01'!F5,'July 02'!F5,'July 03'!F5,'July 04'!F5,'July
05'!F5,'July 06'!F5,'July 07'!F5,'July 08'!F5,'July 09'!F5,'July 10'!F5,'July
11'!F5,'July 12'!F5,'July 13'!F5,'July 14'!F5,'July 15'!F5,'July 16'!F5,'July
17'!F5,'July 18'!F5,'July 19'!F5,'July 20'!F5,'July 21'!F5,'July 22'!F5,'July
23'!F5,'July 24'!F5,'July 25'!F5,'July 26'!F5,'July 27'!F5,'July 28'!F5,'July
29'!F5,'July 30'!F5,'July 31'!F5))

 

[Mayte]

thank both i was playing with it and think i got it ..

=(SUM('July 01'!F6,'July 02'!F6,'July 03'!F6,'July 04'!F6,'July 05'!F6,'July
06'!F6,'July 07'!F6,'July 08'!F6,'July 09'!F6,'July 10'!F6,'July 11'!F6,'July
12'!F6,'July 13'!F6,'July 14'!F6,'July 15'!F6,'July 16'!F6,'July 17'!F6,'July
18'!F6,'July 19'!F6,'July 20'!F6,'July 21'!F6,'July 22'!F6,'July 23'!F6,'July
24'!F6,'July 25'!F6,'July 26'!F6,'July 27'!F6,'July 28'!F6,'July 29'!F6,'July
30'!F6)+SUM('July 31'!F6))/SUM(COUNT('July 01'!F6,'July 02'!F6,'July
03'!F6,'July 04'!F6,'July 05'!F6,'July 06'!F6,'July 07'!F6,'July 08'!F6,'July
09'!F6,'July 10'!F6,'July 11'!F6,'July 12'!F6,'July 13'!F6,'July 14'!F6,'July
15'!F6,'July 16'!F6,'July 17'!F6,'July 18'!F6,'July 19'!F6,'July 20'!F6,'July
21'!F6,'July 22'!F6,'July 23'!F6,'July 24'!F6,'July 25'!F6,'July 26'!F6,'July
27'!F6,'July 28'!F6,'July 29'!F6,'July 30'!F6)+COUNT('July 31'!F6))

Cheers,
Mayte

 

[NBVC]

So then try:

=AVERAGE('July 01:July 31'!F5)

 

[Mayte]

yours works way better ...thanks a lot !!

cheers,
mayte

 

[RagDyer]

NBVC's formula is definately the best way to go, as long as you're
referencing the same cell.

However, I've just averaged *50* non-contiguous cells, using the double
parens, and that procedure worked fine.

Your error message might have something to do with the total length of the
formula ... I really don't know!