| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
If you leave the column of data as it is you can use a modified average
function to ignore the Zero values =AVERAGE(IF(F5:F50<0,F5:F50,"")) note it is array entered - Ctrl Shift Enter a cleaner result IMHO RES In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Threaded Mode
