#### Jerry Sullivan

##### MrExcel MVP

- Joined
- Mar 18, 2010

- Messages
- 8,787

dollars and cents values (2 decimals), but apparently it is.

In the example below, both nearly identical Accounts have a SUM of exactly zero, however

the list of Account B yields a SUMIF result slightly less than zero.

Excel Workbook | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

1 | Account | Balance | Function | Value w/ 15 decimal place display | ||

2 | Acct A | 139.86 | ||||

3 | Acct A | 748.65 | ||||

4 | Acct A | 259.56 | ||||

5 | Acct A | (1,148.07) | SUMIF Acct A | 0.000000000000000 | ||

6 | Acct A | (242.97) | SUBTOTAL Acct A | 0.000000000000000 | ||

7 | Acct A | 242.97 | SUM Acct A | 0.000000000000000 | ||

8 | ||||||

9 | Acct B | 139.86 | ||||

10 | Acct B | 748.65 | ||||

11 | Acct B | 259.56 | SUMIF Acct B | (0.000000000000028) | ||

12 | Acct B | (1,391.04) | SUBTOTAL Acct B | 0.000000000000000 | ||

13 | Acct B | 242.97 | SUM Acct B | 0.000000000000000 | ||

Sheet |

These articles shed some light on the issue....

http://support.microsoft.com/kb/78113

http://www.cpearson.com/excel/rounding.htm

...However I hoping someone can help explain why SUMIF has this limitation but SUM and SUBTOTAL don't?