How can I ignore "" in a formula?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

=IF(A3="",B3+C3,IF(B3="",A3+C3,IF(C3="",A3+B3,A3+B3+C3)))

I have a set of worksheets where a lot of formulas
return "". I am having a hard time figuring out how to
get cells to calculate when the ranges include "". My
latest try is the above formula. But I am naming every
cell in the range and it only works if only one cell
has "". Sometimes it could be all or maybe some
combination. How can I ignore "" in any cell?

TIA

Todd
 
Simple question,

Why not just use =A3 + B3 + C3 (for your example), as far as I know excel
will treat "" as 0 and it shouldn't affect your result???

Dan E
 
=SUM(A3:C3)

will do because SUM ignores text including a formula-generated blank.
 
ok,

the sum if works. How do I get it to work non-consecutive
ranges? like O15+R15+U15.


Todd
 
I have ended up with

=IF(OR(O15<>"", R15<>"",T15<>""), SUM(O15,R15,T15), "")


it seems to work. Thanks for the help!


Todd
 
Non-contiguous ranges can be named as a single range, then use.....

=sum(myrange)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top