How to SUM cells with ISBLANK=FALSE ''''

Copper Contributor

Dear all

Iam applying this Formula in cell D3:

=IF(ISBLANK(B3)=FALSE,ISBLANK(C3)=FALSE),SUM(-B3-C3+D2),"") ==> Answer is 1000

the same formula is applied in cells G9 (Answer is '''', meaning there is nothing to sum in cells E3, F3 and G2).

 

I want then in H3 to SUM (D9+G9) ==> Answer is #VALUE!

I want to have 1000 instead of #VALUE

As the Revenues for this year is 1000

Pb in Excel.PNG

 

Thanks a lot for your help !

Anto

 

3 Replies
Modify your formula in H3 from =SUM(D3+G3) to =SUM(D3,G3).
Thanks ! That was a mistake. Same formula for line 4 gives me 0. How can I have a BLANK cell instead
In that case, you may construct your formula in H3, this way:
=IF((D3="")*(G3=""),
"",
SUM(D3,G3)