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!