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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
2003 Excel Averages Question - Novice User!
- Thread starter klacuna
- Start date
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Try entering with CTRL+Shift+Enter
=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
Upvote
0
Good Morning!
I have columns of monthly QC data based on the items in each row. I have averaged monthly at the bottom of each column, and at the end of each row to get a year to date average for each item and month. There are a few items that are quarterly so there is no monthly data yet, so my overall year to date of all items won't calculate due to the missing quartely data. So I can't fix the error due to the lack of data. Does this make sense? Thanks for all of your help!
I have columns of monthly QC data based on the items in each row. I have averaged monthly at the bottom of each column, and at the end of each row to get a year to date average for each item and month. There are a few items that are quarterly so there is no monthly data yet, so my overall year to date of all items won't calculate due to the missing quartely data. So I can't fix the error due to the lack of data. Does this make sense? Thanks for all of your help!
Upvote
0
Similar threads
- Question
