If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
min,average0 if 52 cells read zero
=MIN(IF(A1:A1000,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 |
Thread Tools | |
Display Modes | |
|
|