 • 409K Members
• 7,123 Online
• 466K Conversations

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

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 Thanks a lot for your help !

Anto

3 Replies

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

Modify your formula in H3 from =SUM(D3+G3) to =SUM(D3,G3).

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

Thanks ! That was a mistake. Same formula for line 4 gives me 0. How can I have a BLANK cell instead

Re: RE: How to SUM cells with ISBLANK=FALSE ''''

In that case, you may construct your formula in H3, this way:
=IF((D3="")*(G3=""),
"",
SUM(D3,G3)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies