out of intrest what is the value of C3
The colum you posted adds up to 0.00 when I tested

"Michele" wrote:

prentheisis was just a typo on my part. As far as VBA i don't understand what
that is, i just went to the fomula bar and typed in the formula i wanted to
use. I use that formula all the time so i know it by heart.

I appriciate you efforts. Thank you for trying

"steve_doc" wrote:

Totaly stumped
unless
are you setting the format via VBA?
in the format block you posted your parenthesis do not match, not sure if
that could be the cause?

"Michele" wrote:

i thought of the rounding error but that is not the case my formula is as
follows: =C3-SUM(J7:J65536) this formula is adding up the following amounts:
- $ 400.00
- $ 923.45
$ 60.00
$ 36.00
$ 44.00
$ 283.18
$ 36.00
$ 36.00
$ 200.00
$ 145.10
$ 127.35
$ 35.50
$ 30.60
$ 162.60
$ 106.32
$ 20.80
the format i have used is in these cells is: $ #,##0.00;[Red}-$ #,##0.00