LinkBack URL
About LinkBacks
I am trying to average a range of cells =AVERAGE(I4:I10) but I have data that is blank. How do I write the formula to average the cells andskip no value cells but still accept zero's?
Average a range of data but exclude blank data
I am trying to average a range of cells =AVERAGE(I4:I10) but I have data that is blank. How do I write the formula to average the cells andskip no value cells but still accept zero's?
Try this:
since you use excel 2007+
Please Login or Register to view this content.
Quang PT
Doesn't the formula already ignore blanks, and include 0's?... it should.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Re: Average a range of data but exclude blank data
Thanks for the help but I have a cell that still giving me issues see attached. I may have the formual wong in the first place on cells H10, I10, and J10.
It returns #DIV/0 because of C10=0, to avoid, use this in I10:
returns 0% if C10=0Please Login or Register to view this content.
Copy to J10.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks