excel_training_wheels
Board Regular
- Joined
- Aug 25, 2005
- Messages
- 193
Hi--
Anyone have a suggestion on how to calculate an average if the column currently is populated with the following? Column A has months, column B has numbers
Column A/B
Jan 32.4
Feb 21.8
Mar 19.7
Apr 51.6
May #DIV/0!
Jun #DIV/0!
There are formulas in the cells in column B which are calculating the numbers above... may and june return an error (which is ok...) I just want the average where the cell value does not equal #DIV/0!.
Anyone have a suggestion on how to calculate an average if the column currently is populated with the following? Column A has months, column B has numbers
Column A/B
Jan 32.4
Feb 21.8
Mar 19.7
Apr 51.6
May #DIV/0!
Jun #DIV/0!
There are formulas in the cells in column B which are calculating the numbers above... may and june return an error (which is ok...) I just want the average where the cell value does not equal #DIV/0!.