|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
|
|
Thread Tools | Display Modes |
Mar 26th, 2003, 12:40 AM
|
#1 |
|
Join Date: Mar 2003
Posts: 20
|
Averages..problem with 0s...can you please help!
I have a column with values in it. Some are 0s and some values are not. If I average the column, it gives me the average of all the values including the 0s. How do I make excel not count the 0s in computing an average?
Thanks! |
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode