NONFUNCTIONING FORMULA

R

Roodbwoye

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
 
G

Gord Dibben

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

Deposit 20

Withdrawl -20


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
EXcel IF function 1
Auto Sum not working correctly 1
Display weeks from a Milestone 0
proper formula or function 1
divided value by amount of rows 2
Multiple Conditions 2
Sumproduct or ???? 2

Top