• 547K Members
• 2,662 Online
• 652K Conversations

Highlighted
New Contributor

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

Dear all

Iam applying this Formula in cell D3:

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
Highlighted

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

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

# 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
Highlighted

# 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
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies