| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MIN & AVERAGE ignore 0
I am trying to get min & average 0n cells
G5,K5,O5,S5W5,AA5,AE5,AI5,AM5,AQ5,AU5,AY5,BC5,BG5, BK5,BO5,BS5,BW5,CA5,CE5,CI5,CM5,CQ5,CU5,CY5,DC5,DG 5,DK5,DO5,DS5,DW5,EA5,EE5,EI5,EM5,EQ5,EU5,EY5,FC5, FG5,FK5,FO5,FS5,FW5,GA5,GE5,GI5,GM5,GQ5,GU5,GY5,HC 5, all these cells have zero,s until data is entered on seperate work sheets these cells im trying to min or average = 52 weeks so i want the min & average to be calculated as each weeks data is entered can anyone please help I TRIED ALOT OF DIFFERENT FORMULAS BUT I CAN,T GET IT TO WORK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I average a group of cells and ignore a #div/0! error? | Excel Discussion (Misc queries) | |||
| ignore #NA in average formula | Excel Discussion (Misc queries) | |||
| ignore MAX and MIN values in a set to calculate average | Excel Discussion (Misc queries) | |||
| How to make average function ignore MIN and MAX | Excel Worksheet Functions | |||
| Average calcs - ignore sheets | Excel Worksheet Functions | |||
Threaded Mode
