Hi Everyone,
First time user, long time viewer. OK, I have a cell range that each cell contains a projection of sales on a given day, one cell = one day. The actual sales are logged daily in the range below the projection range, the cell that contains the total for actuals I would like to sum the actuals revenues and then I would like to add the projected sales when the actual = 0 or blank.