sumif for non-blank, non-contiguous cells

[TMLstan]

I am trying to write a formula to total data in column C and column E (C+E) only when C or E have data. In other words, when C and E are blank, i would like the formula to return "-". When C or E have data, including a 0, i would like the formula to add C+E.

My only experience with sumif is for ranges, e.g. contiguous data.

My initial alternative was =if(c8+d8>=0,c8+d8,"-") but, for some reason, that returns a 0 even though c8 and d8 are blank.

I have also tried, =if(c8<>"",c8,"-")+if(e8<>"",e8,"-"). This returns a #VALUE ! error.

Any suggestions?

 

[JoeMo]

=if(or(isblank(c8),isblank(e8)),"-",c8+e8)

 

[TMLstan]

=if(or(isblank(c8),isblank(e8)),"-",c8+e8)

Yes, I can make this work JoeMo.

As I implemented your formula, I found an exception that I had not foreseen when I posted my question. What I was looking for when I posted, was to return "-" for the rows in which there was no data. Your solution solves that. What I discovered is that several of the rows for which I do have data, have data in only one of the Columns (C or E) and a blank in the other.

If there is not another way, I can solve that by requiring the managers to enter either data or a zero on each date (row) they complete. Your formula will correctly process this result. If there is a way to accommodate them leaving one of the columns blank if they have no data while completing the other, that would be even better.

Thanks for your quick response.

 

[JoeMo]

If you only want "-" returned when both C8 & E8 are blank, just change OR to AND like this:

=if(and(isblank(c8),isblank(e8)),"-",c8+e8)

 

[TMLstan]

If you only want "-" returned when both C8 & E8 are blank, just change OR to AND like this:

=if(and(isblank(c8),isblank(e8)),"-",c8+e8)

AMAZING. Why didn't I think of that?

It may seem easy to you...don't underestimate how much your help is appreciated.

Thank you very much.