I made a simple spreadsheet to calculate my daily blood sugar levels and monthly average. Some days I do not test my blood sugar levels and the 'average' cell displays #DIV/0!. Can I make the AVERAGE formula ingnore the days I do not have any entries instead of displaying #DIV?0!? The end of the month average (which averages the daily averages) also displays the same. I hope this is a simple fix and my inexperience with Excel is to blame. Thanks!
Good morning tizmylife
...and welcome to the forum!!
Try incorporating IFERROR into your formula, thus :
Formula:
Please Login or Register to view this content.
HTH
DominicB
For excel 2007 + only
Another option: AVERAGEIF(A1:A10,>0)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks