| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging, but excluding zeros
i have weekly inventory in a spreadsheet....but the columns are not right
next to eachother...for example columns a, c, e, and g have inventory.....Sales may be in column b,d,f and h. I need a formula in column z that averages a,c,e and g. But if the inventory is zero, don't average it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging numbers in a column while excluding blank spaces and zer | Excel Worksheet Functions | |||
| averaging separate cells in excel excluding 0 values | Excel Discussion (Misc queries) | |||
| Averaging excluding blanks--Multiple Tabs | Excel Worksheet Functions | |||
| Averaging excluding min and max numbers | Excel Worksheet Functions | |||
| Averaging with zeros NOT | Excel Discussion (Misc queries) | |||
Threaded Mode
