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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
min,average0 if 52 cells read zero
Mike,
The easiest thing to do is to completely empty all your data cells, or have formulas that fill the averaged cells with "" until you enter data, and Excel will ignore them for numeric calculations. HTH, Bernie MS Excel MVP "Mike" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
min,average0 if 52 cells read zero
=MIN(IF(A1:A100<0,A1:A100,""))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. Similar for average. -- Gary''s Student - gsnu200908 "Mike" wrote: 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 |
Reply |
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) |