| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
min,average0 if 52 cells read zero
I have 52 cells w265 that all read zero until data is entered this means one
cell in each worksheet example Week 1 w265, week 2 w265, week 3 w265 to week 52 w265. on a seperate work sheet im trying to caculate min & average for efficiency but when data is entered for min i get zero because of other cells that read zero or the average is incorrect too low I have to have zero,s in place on the 52 worksheets but i don,t want io include them when calculating min or average on seperate work sheet can some please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| min & average 52 work sheets all read zero | Excel Discussion (Misc queries) | |||
| i need the cells to read 9-1 and it won't work | Excel Discussion (Misc queries) | |||
| Can you set certain cells as read only? | Excel Discussion (Misc queries) | |||
| trying to sum columns in which some cells read n/a | Excel Discussion (Misc queries) | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
Threaded Mode
