# Formula not adding minus figures

#### Donal28

##### Well-known Member
Hi All

I'm havng a really strange problem with what seems a simple formulas works in one spreadsheet but not the other!! the formula simply adds 2 numbers together in Cell N10

=IF(N8="","",SUM(N8:N9))

However when the same for is used in another spreadsheet and the N9 cell is a minus figure e.g. -1 then the N10 cell just goes blank. There is no conditional formatting in the cell N10 and the formatting is set to minus number with 0 decimal places so I cannot figure out what is going on!!!

Any help on this would be very much apprecaited

Regards
Donal

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
are you sure that the cell is formatted to a number rather than text ? Thanks

Regards

Kaps

Yes its definitely formatted to a number

If this formula returns a blank

=IF(N8="","",SUM(N8:N9))

...then I assume that N8 is blank

yes thats right N8 is blank but I just want the formula to add N8:N9 even if one of the the cells is blank

The formula you are using is explicitly returning a blank if N8 is blank - if you just want the SUM try simply

=SUM(N8:N9)

or if you want a blank only when neither cell contains a number try

=IF(COUNT(N8:N9),SUM(N8:N9),"")

The formula you are using is explicitly returning a blank if N8 is blank - if you just want the SUM try simply

=SUM(N8:N9)

or if you want a blank only when neither cell contains a number try

=IF(COUNT(N8:N9),SUM(N8:N9),"")

Yes thats worked fine, thanks for your help

Replies
8
Views
120
Replies
8
Views
312
Replies
1
Views
159
Replies
2
Views
98
Replies
4
Views
248

1,202,993
Messages
6,052,970
Members
444,623
Latest member
elbertzeeroone

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