I wrote essentially this same post and it disappeared. Either I'm losing it or Tek-Tips is! If it suddenly reappears and posts and you see it twice please don't think I'm any crazier than I actually am!
I have no idea what happened with the formatting issue. For some unknown reason it resolved itself. I have a photo of it before so you can see what I was seeing.
And the two other columns displayed don't sum to the third column because they're not the two that are being compared.
Sorry the photo is so big. It was a snap from my cellphone, not a screenshot, and I was too lazy to reduce it.
Regardless, it's completely irrelevant at this point. Everything is working great.
Combo, I decided to go back to my original format of +#,###;-#,###[Red];0;"Empty" because the empty set left the field blank when the result was 0. I also removed the decimal point in the negative numbers since these are integers only.
You guys are stars and you deserve stars on your posts for all the help. I've already done it.
I really do appreciate the efforts you put forth for strangers.