| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
min & average 52 work sheets all read zero
i need min & average formula for work sheets 1 to 52 the cell im trying to
average or get min is W265 & all read 0% until data is entered for each week 1 to 52 when i try to fomulate i get a value or ref error can any please help!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
min & average 52 work sheets all read zero
What formulae have you tried? I would suggest these:
=MIN(Sheet1:Sheet52!W265) and =AVERAGE(Sheet1:Sheet52!W265) but instead of having 0% in those cells on sheets where there is no data, I would suggest you return an empty string "". Hope this helps. Pete On Nov 10, 2:28*am, Mike wrote: i need min & average formula for work sheets 1 to 52 the cell im trying to average or get min is W265 & all read 0% until data is entered for each week 1 to 52 when i try to fomulate i get a value or ref error can any please help!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need the cells to read 9-1 and it won't work | Excel Discussion (Misc queries) | |||
| Help getting macro to work in read only | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
| In Excel is there a way to read the name of the sheets tab and di. | Excel Worksheet Functions | |||
Linear Mode
