Show blank when formula do not find any values.

Question

Hello

I want that when C304 have no value then D 304 should be blank

pelase advice

Answer 1

In D304, use this formula:

=IF(C304="","",SUM(C$15:C304))

Then copy the formula down column D.

This will keep D blank whenever the corresponding C cell is blank. If C304 contains a value, D304 will calculate the cumulative sum from C15 through C304.

For example, if C304 is blank, D304 will be blank. If C304 contains 10, D304 will show the cumulative total including that 10.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 2

Use an IF check before the formula so D304 stays blank when C304 is blank.

If only C304 controls whether D304 should show a result, use:

=IF(C304="","",YourFormula())

If the current formula in D304 is a running total such as SUM(C$1:C304), use:

=IF(C304="","",SUM(C$1:C304))

If the formula already uses IFERROR, combine them like this:

=IF(C304="","",IFERROR(SUM(C$1:C304),""))

This works because "" tells Excel to display nothing when C304 has no value.

---

• Using IF to check if a cell is blank
• Display or hide zero values