I would like to average a column of numbers that is missing one number and shows a #DIV/0! in one box of the column. How would I write a formula to have excel automatically skip that information and average the remainig numbers? At this time, I received the same error #DIV/0! at the column average cell. Thanks so much for helping a newbee!