Formula that doesn't include blanks

  • Hello, it's been a while!

    First, Sorry if my title isn't good, but I really can't figure out how to summarize what I need for a proper title.

    I have a simple workbook that keeps track of odometer readings. I'd like to have a column that shows the Year To Date Odometer reading based on the data entered every quarter. The problem is some cells will be blank because we haven't go to that quarter yet so it is not giving me proper results. The formula that was tried is "=F8-E8+G8-F8+H8-G8+I8-H8". This formula works if all the cells have data, but if there blanks it doesn't work. I've attached a sample for review.

    Does anyone have any suggestions? My brain just isn't cooperating today. Thanks in advance.


    • OzSample.xlsx

      (13.08 kB, downloaded 106 times, last: )