Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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 -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109718 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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! ================================================== === "Mayte" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
yes
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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)) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
So then try: =AVERAGE('July 01:July 31'!F5) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109718 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
yours works way better ...thanks a lot !!
cheers, mayte |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for 31 arguments
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! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mayte" wrote in message ... yours works way better ...thanks a lot !! cheers, mayte |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too few arguments | Excel Worksheet Functions | |||
IF-more than 7 arguments in | Excel Worksheet Functions | |||
How can I place more than 30 arguments in an average function? | New Users to Excel | |||
AVERAGE more than 30 arguments? | Excel Worksheet Functions | |||
Are there too many arguments | Excel Worksheet Functions |