NONFUNCTIONING FORMULA
 

Can anyone help me figure out why a formula would stop functioning? I set up
a check register and had the formula =SUM(D2:F2993) to render the balance of
the w/d and deposit. It should calculate al the way to row 2993 however row
371 started adding the w/d to the balance. I can not only find the error but
I don't know how to fix it if I found it.

I apreciate any suggestions
--
Respectfully
Rood

NONFUNCTIONING FORMULA
 

Maybe someone forgot to enter the w/d as negative?

Deposit 20

Withdrawl -20


Gord Dibben MS Excel MVP

On Fri, 2 Apr 2010 12:34:01 -0700, Roodbwoye
wrote:

Can anyone help me figure out why a formula would stop functioning? I set up
a check register and had the formula =SUM(D2:F2993) to render the balance of
the w/d and deposit. It should calculate al the way to row 2993 however row
371 started adding the w/d to the balance. I can not only find the error but
I don't know how to fix it if I found it.

I apreciate any suggestions