LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Average more than 30 numeric arguments

Thanks RD

Probably got to the formula 1024 character limit.


Gord


On Mon, 17 Aug 2009 12:10:31 -0700, "RagDyer" wrote:

Using that "trick" you showed me Gord (<Shift <F8), I got 236 cells to
work before the "Formula Too Long" error popped up.

BTW, it (<Shift <F8) also works well for selecting non-contiguous cells
for the "Named Range" data entry procedure.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average for 31 arguments Mayte Excel Discussion (Misc queries) 8 June 24th 09 08:12 PM
How can I place more than 30 arguments in an average function? pjr New Users to Excel 13 March 27th 08 03:30 PM
AVERAGE more than 30 arguments? Raza Excel Worksheet Functions 4 September 23rd 05 09:48 PM
AVERAGE Row of Numbers and Return Corresponding Numeric Label Sam via OfficeKB.com Excel Worksheet Functions 14 September 20th 05 01:07 AM
How to average every 10 numeric values emel24 Excel Worksheet Functions 4 August 11th 05 08:29 AM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"