Excel not summing like it normally does

[zookeepertx]

I have a spreadsheet where I'm comparing the financial data for a group of files from last month to this month. I'm trying to find any discrepancies between each file's data from last month to this month. But with 400 or so lines from each month, it's tough to compare them 2 rows at a time.
So, I have the set of data once from last month, then, below that, I have the set of data from this month. Then I flip the sign of this month's data, so that, hopefully, the sum of the column is zero. So far, all is good; if I highlight a column, it gives me the correct sum, usually zero. Then I sort them so that the 2 rows for each file are together. Here's where the problem starts: If I then highlight, for example, E3:E4, the box at the top of the sheet gives me E3 as the total, but at the bottom of the spreadsheet says the sum is zero. In fact, at that point, if I highlight the whole column, it gives me E3 as the sum. Same with each of the other columns!
The data goes over through column R. In column S, to compare E3:E4 I tried putting this

=if(E3:E4=0,"",E3:E4)

. This would then be dragged across to compare all the columns of data & dragged down to find which files have a discrepancy. However, when I put that formula in S3, it gives me the number in E4 as the answer when it should be blank because E3+E4 IS zero! If I put an autosum in S3 to sum E3 & E4, it says 0 like it should!
This is the craziest thing I've ever seen! Even stranger, if I re-sort the rows back to last month's data at the top & this month's data at the bottom, NOW the problems stay.
Here's a short example of the sheet before sorting:

[TABLE="width: 713"]
<TBODY>[TR]
[TD="class: xl65, width: 56, bgcolor: transparent"]A
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]B
[/TD]
[TD="class: xl65, width: 25, bgcolor: transparent"]C
[/TD]
[TD="class: xl65, width: 86, bgcolor: transparent"]D
[/TD]
[TD="class: xl65, width: 65, bgcolor: transparent"]E
[/TD]
[TD="class: xl65, width: 33, bgcolor: transparent"]F
[/TD]
[TD="class: xl65, width: 49, bgcolor: transparent"]G
[/TD]
[TD="class: xl65, width: 49, bgcolor: transparent"]H
[/TD]
[TD="class: xl65, width: 43, bgcolor: transparent"]I
[/TD]
[TD="class: xl65, width: 59, bgcolor: transparent"]J
[/TD]
[TD="class: xl65, width: 59, bgcolor: transparent"]K
[/TD]
[TD="class: xl65, width: 65, bgcolor: transparent"]L
[/TD]
[TD="class: xl65, width: 59, bgcolor: transparent"]M
[/TD]
[TD="class: xl65, width: 33, bgcolor: transparent"]N
[/TD]
[TD="class: xl65, width: 33, bgcolor: transparent"]O
[/TD]
[TD="class: xl65, width: 59, bgcolor: transparent"]P
[/TD]
[TD="class: xl65, width: 49, bgcolor: transparent"]Q
[/TD]
[TD="class: xl65, width: 37, bgcolor: transparent"]R
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: white"]Broker File Number
[/TD]
[TD="class: xl67, bgcolor: white"]Age
[/TD]
[TD="class: xl67, bgcolor: white"]Vendor/Co/Dept
[/TD]
[TD="class: xl68, bgcolor: white"]First
[/TD]
[TD="class: xl68, bgcolor: white"]Bank
[/TD]
[TD="class: xl68, bgcolor: white"]Additional
[/TD]
[TD="class: xl68, bgcolor: white"]FRT
[/TD]
[TD="class: xl68, bgcolor: white"]BRO
[/TD]
[TD="class: xl68, bgcolor: white"]DTY
[/TD]
[TD="class: xl68, bgcolor: white"]Loads
[/TD]
[TD="class: xl68, bgcolor: white"]Inv
[/TD]
[TD="class: xl68, bgcolor: white"]Inv
[/TD]
[TD="class: xl68, bgcolor: white"]Claims
[/TD]
[TD="class: xl68, bgcolor: white"]GL Acct
[/TD]
[TD="class: xl68, bgcolor: white"]TRUE
[/TD]
[TD="class: xl68, bgcolor: white"]TRUE
[/TD]
[TD="class: xl68, bgcolor: white"]Balance
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: white"][/TD]
[TD="class: xl67, bgcolor: white"][/TD]
[TD="class: xl67, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"]Cost
[/TD]
[TD="class: xl68, bgcolor: white"]Fee
[/TD]
[TD="class: xl68, bgcolor: white"]Fees
[/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"]Recpts
[/TD]
[TD="class: xl68, bgcolor: white"]Adj
[/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"]Recpts
[/TD]
[TD="class: xl68, bgcolor: white"]ROE Var
[/TD]
[TD="class: xl68, bgcolor: white"]LC Var
[/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: #99ccff"]130080346
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]151
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]22129/960
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]10,249.07
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]134.35
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]1.88
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]1,085.33
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]717.44
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](14,426.83)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]1,766.98
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](201.57)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]673.35
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: #99ccff"]130082036
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]74
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]22129/517
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]30,308.22
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]975.61
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]71.33
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]3,155.76
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]2,121.58
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](35,356.33)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.31
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](1,319.39)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]42.91
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: #99ccff"]130082118
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]66
[/TD]
[TD="class: xl70, bgcolor: #99ccff"]22129/517
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]40,677.08
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]756.91
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]10.42
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]4,264.68
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]2,847.40
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](47,860.30)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.48
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl71, bgcolor: #99ccff"](1,436.23)
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]739.56
[/TD]
[TD="class: xl71, bgcolor: #99ccff"]0.00
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #66ffff"]130080346
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]179
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]22129/960
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](10,249.07)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](134.35)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](1.88)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](1,085.33)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](717.44)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]14,426.83
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](1,766.98)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]201.57
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](673.35)
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]0.00
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #66ffff"]130082036
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]102
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]22129/517
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](30,308.22)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](975.61)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](71.33)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](3,155.76)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](2,121.58)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]35,356.33
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](0.31)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1,319.39
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](42.91)
[/TD]
[TD="class: xl75, bgcolor: #66ffff"](0.00)
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #66ffff"]130082118
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]94
[/TD]
[TD="class: xl73, bgcolor: #66ffff"]22129/517
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](40,677.08)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](756.91)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](10.42)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](4,264.68)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](2,847.40)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]47,860.30
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](0.48)
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1,436.23
[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"](739.56)
[/TD]
[TD="class: xl75, bgcolor: #66ffff"](0.00)
[/TD]
[/TR]
</TBODY>[/TABLE]

and after sorting, with the formula in S3:

[TABLE="width: 724"]
<TBODY>[TR]
[TD="class: xl67, width: 14, bgcolor: transparent"]A
[/TD]
[TD="class: xl67, width: 89, bgcolor: transparent"]B
[/TD]
[TD="class: xl67, width: 25, bgcolor: transparent"]C
[/TD]
[TD="class: xl67, width: 86, bgcolor: transparent"]D
[/TD]
[TD="class: xl67, width: 65, bgcolor: transparent"]E
[/TD]
[TD="class: xl67, width: 33, bgcolor: transparent"]F
[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]G
[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]H
[/TD]
[TD="class: xl67, width: 43, bgcolor: transparent"]I
[/TD]
[TD="class: xl67, width: 59, bgcolor: transparent"]J
[/TD]
[TD="class: xl67, width: 59, bgcolor: transparent"]K
[/TD]
[TD="class: xl67, width: 65, bgcolor: transparent"]L
[/TD]
[TD="class: xl67, width: 59, bgcolor: transparent"]M
[/TD]
[TD="class: xl67, width: 33, bgcolor: transparent"]N
[/TD]
[TD="class: xl67, width: 33, bgcolor: transparent"]O
[/TD]
[TD="class: xl67, width: 59, bgcolor: transparent"]P
[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]Q
[/TD]
[TD="class: xl67, width: 37, bgcolor: transparent"]R
[/TD]
[TD="class: xl66, width: 56, bgcolor: transparent"]S
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: white"]Broker File Number
[/TD]
[TD="class: xl69, bgcolor: white"]Age
[/TD]
[TD="class: xl69, bgcolor: white"]Vendor/Co/Dept
[/TD]
[TD="class: xl70, bgcolor: white"]First
[/TD]
[TD="class: xl70, bgcolor: white"]Bank
[/TD]
[TD="class: xl70, bgcolor: white"]Additional
[/TD]
[TD="class: xl70, bgcolor: white"]FRT
[/TD]
[TD="class: xl70, bgcolor: white"]BRO
[/TD]
[TD="class: xl70, bgcolor: white"]DTY
[/TD]
[TD="class: xl70, bgcolor: white"]Loads
[/TD]
[TD="class: xl70, bgcolor: white"]Inv
[/TD]
[TD="class: xl70, bgcolor: white"]Inv
[/TD]
[TD="class: xl70, bgcolor: white"]Claims
[/TD]
[TD="class: xl70, bgcolor: white"]GL Acct
[/TD]
[TD="class: xl70, bgcolor: white"]TRUE
[/TD]
[TD="class: xl70, bgcolor: white"]TRUE
[/TD]
[TD="class: xl70, bgcolor: white"]Balance
[/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl69, bgcolor: white"][/TD]
[TD="class: xl69, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"]Cost
[/TD]
[TD="class: xl70, bgcolor: white"]Fee
[/TD]
[TD="class: xl70, bgcolor: white"]Fees
[/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"]Recpts
[/TD]
[TD="class: xl70, bgcolor: white"]Adj
[/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl70, bgcolor: white"]Recpts
[/TD]
[TD="class: xl70, bgcolor: white"]ROE Var
[/TD]
[TD="class: xl70, bgcolor: white"]LC Var
[/TD]
[TD="class: xl70, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #99ccff"]130080346
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]151
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]22129/960
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]10,249.07
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]134.35
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]1.88
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]1,085.33
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]717.44
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](14,426.83)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]1,766.98
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](201.57)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]673.35
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: #66ffff"]130080346
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]179
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]22129/960
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](10,249.07)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](134.35)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](1.88)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](1,085.33)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](717.44)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]14,426.83
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](1,766.98)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]201.57
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](673.35)
[/TD]
[TD="class: xl77, bgcolor: #66ffff"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]-10249.1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #99ccff"]130082036
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]74
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]22129/517
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]30,308.22
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]975.61
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]71.33
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]3,155.76
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]2,121.58
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](35,356.33)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.31
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](1,319.39)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]42.91
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: #66ffff"]130082036
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]102
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]22129/517
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](30,308.22)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](975.61)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](71.33)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](3,155.76)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](2,121.58)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]35,356.33
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](0.31)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]1,319.39
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](42.91)
[/TD]
[TD="class: xl77, bgcolor: #66ffff"](0.00)
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #99ccff"]130082118
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]66
[/TD]
[TD="class: xl72, bgcolor: #99ccff"]22129/517
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]40,677.08
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]756.91
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]10.42
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]4,264.68
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]2,847.40
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](47,860.30)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.48
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="class: xl73, bgcolor: #99ccff"](1,436.23)
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]739.56
[/TD]
[TD="class: xl73, bgcolor: #99ccff"]0.00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: #66ffff"]130082118
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]94
[/TD]
[TD="class: xl75, bgcolor: #66ffff"]22129/517
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](40,677.08)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](756.91)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](10.42)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](4,264.68)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](2,847.40)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]47,860.30
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](0.48)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]0.00
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]1,436.23
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"](739.56)
[/TD]
[TD="class: xl77, bgcolor: #66ffff"](0.00)
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

Can anyone explain this?
Thanks!

 

[Joe4]

A few comments:

- Are you values entered as Text or Numbers? Entering numerical values as Text can do unexpected things in formulas. If your entries are left-justified, that is often a sign that they are entered as Text. Change them to numerical entries (can change the column Format and use Text-to-Columns to do this).

- If you are looking for a SUM, this is NOT the way to do it:

=if(E3:E4=0,"",E3:E4)

this is:

=IF(SUM(E3:E4)=0,"",SUM(E3:E4))

 

[zookeepertx]

Hi Joe,

Yes, all my numbers are formatted as numbers. As for the formula, oh DUHHH! I know that! I don't know what's wrong with my brain today! Sometimes I wonder IF I have a brain! It works fine now. The really embarrassing part is that I do this EVERY. DANG. MONTH. It usually goes just fine, but this month... well, I dunno!
Thanks!

Jenny

 

[Joe4]

So are you all set then?

BTW, love your signature!

 

[zookeepertx]

Yep, all set... till the next weird thing comes up, LOL!
Thanks - that CDO line is my favorite joke!