# only calculate cells with numbers

#### DButler

##### Board Regular
I have a formula summing 2 cells. Sometimes one or both of the cells are #value, or something other than a number, which is normal. I would like my formula to ignore the cell if it is not a number and use the other, or if both are not a number, enter a 0 in the cell.

DB

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### vds1

##### Well-known Member
Suppose your two cells are A1 and A2 then you can try this formula

=SUMIF(A1:A2,"<>#VALUE!")

#### TrumpExcel

##### Board Regular
Try this (considering data is in A1 and B1)

=SUM(--IF(ISNUMBER(A1:B1),A1:B1))

Use Control + Shift + Enter instead of Enter

Replies
4
Views
161
Replies
5
Views
105
Replies
5
Views
111
Replies
2
Views
334
Replies
11
Views
253

1,195,666
Messages
6,011,043
Members
441,580
Latest member
BornholmerBjarne

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back