Sum a range if >0 if false then sum different range or part of range

[nunzino]

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.

[hrlngrv]

If projections were in E7:Z7, actuals in E8:Z8 but some cells on the right 0 or empty (question: could actual sales be zero?), you could use something like

=SUM(E8:Z8,SUMIFS(E7:Z7,E8:Z8,{"=";0}))

To include projections only when actuals are blank,

=SUM(E8:Z8,SUMIFS(E7:Z7,E8:Z8,"="))

[nunzino]

Thank you first option worked perfectly!!!
Nunz

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.