i think what i am trying to do is pretty simple but i cant figure it out. Basically i have two totals i want to add....so =A4+B4
Sometimes B4 will be blank but i still want to show the value of A4 with this formula.
So in some cases =10+20 equals 30
in other cases =10+(blank value) equals 10