Formula and Empty Cells

[Brian]

Hi there

I am using SUM to total my values in a column but some value are blank. So
my result show in the end is correct but with a small green arrow on the top
left corner. Is my total right or how to ignore that green arrow?

Cheers

 

[CVinje]

Most likely it's an error indicator - Excel thinks you accidentally omitted
some cells. I don't know if you did or not, but if your total is correct, you
can ignore it, or hide it by doing the following:

Hide error indicators in cells:
If a cell contains a formula that breaks one of the rules, a triangle
appears in the top-left corner of the cell. You can prevent these indicators
from being displayed.

1)On the Tools menu, click Options and then click the Error Checking tab.
2)Clear the Enable background error checking check box.

 

[Brian]

Thank you for your help.

Cheers

 

[xlmate]

Although the solution provided did what you want, but personally,it is not
advisable to turn off error checking featureas it help you to identify errors
easily which
otherwise take hours to find if you worksheet is large.

Since you result is correct, you may just ignore the alert provided by the
error
checking feature.

You may use this formula =SUMIF(A2:A10,"<>""") which will ignore blank cells
when summing.
--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis

 

[CVinje]

Excellent point!

Although the solution provided did what you want, but personally,it is not
advisable to turn off error checking featureas it help you to identify errors
easily which
otherwise take hours to find if you worksheet is large.

Since you result is correct, you may just ignore the alert provided by the
error
checking feature.

You may use this formula =SUMIF(A2:A10,"<>""") which will ignore blank cells
when summing.
--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis