| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
min ,max,average
i am using office 2007 & im trying to get min,max,average from 52 different
worksheets using cell W265 in each worksheet which reads 0% when i try to formulate i get a (value or ref error) this formula that i am trying is entered in a seperate worksheet from the 52 can someone please help !!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
min ,max,average
I am not sure I understood what you are looking for.. If you are referring to
the error for AVERAGE() try the below. Edit the sheetnames if there are not named as Sheet1 and Sheet52. Sheet1 is the 1st sheet. If you have named that as 1,2,3 etc; then =MAX(1:52!A1) Try the below... =MAX(Sheet1:Sheet52!W265) =MIN(Sheet1:Sheet52!W265) =AVERAGE(0,Sheet1:Sheet52!W265) If this post helps click Yes --------------- Jacob Skaria "Mike" wrote: i am using office 2007 & im trying to get min,max,average from 52 different worksheets using cell W265 in each worksheet which reads 0% when i try to formulate i get a (value or ref error) this formula that i am trying is entered in a seperate worksheet from the 52 can someone please help !!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
min ,max,average
...correction
=MAX(Sheet1:Sheet52!W265) =MIN(Sheet1:Sheet52!W265) =AVERAGE(Sheet1:Sheet52!W265) OR =IF(COUNT(Sheet1:Sheet52!W265), SUM(Sheet1:Sheet52!W265)/COUNT(Sheet1:Sheet52!W265),"") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: I am not sure I understood what you are looking for.. If you are referring to the error for AVERAGE() try the below. Edit the sheetnames if there are not named as Sheet1 and Sheet52. Sheet1 is the 1st sheet. If you have named that as 1,2,3 etc; then =MAX(1:52!A1) Try the below... =MAX(Sheet1:Sheet52!W265) =MIN(Sheet1:Sheet52!W265) =AVERAGE(0,Sheet1:Sheet52!W265) If this post helps click Yes --------------- Jacob Skaria "Mike" wrote: i am using office 2007 & im trying to get min,max,average from 52 different worksheets using cell W265 in each worksheet which reads 0% when i try to formulate i get a (value or ref error) this formula that i am trying is entered in a seperate worksheet from the 52 can someone please help !!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
