LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 195
Default why can't I average 36 values?

hi Dave,

You should answer back in the Questioner's forum. Your answers are
always good, but I need the questions too.

Hope you will help me too to understand your posts.


Thanks,

Shail


Dave F wrote:
What formula are you using?

I'm not aware of such a limit, however, if there were such a limit, the
solution would be to split the range of cells to be averaged into to ranges,
average each of those ranges, and then average the two averages.

Dave
--
Brevity is the soul of wit.


"pingwin77" wrote:

I am trying to average 36 seperate values in 36 different cells but I keep
getting an error. Is there a limit on how many cells can be used in a
function? If not, what am I doing wrong? If there is a limit, how do I get
around this issue?


 
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 Values / Multiple Worksheets George Reis Excel Worksheet Functions 5 January 31st 06 10:27 PM
Conditional math using AND, Average Team ZR-1 Excel Worksheet Functions 12 January 19th 06 10:59 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
How to average a column, but exclude zero AND negative values? KMHarpe Excel Discussion (Misc queries) 1 July 20th 05 10:06 PM
How do I average a formula without calculating zero values? KMHarpe Excel Discussion (Misc queries) 1 July 20th 05 06:05 PM


All times are GMT +1. The time now is 05:02 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"