View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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