Hello,
I have a checking account ledger made with excel, pretty simple ledger. My
question is this i have a column right before the amount column that says
reconciled (meaing that it has hit my statement online) the amount column i
enter it in either negative or positve and then i have a cell that says
Available balance this i got by just using the sum of the amount column, no
my question is this i am attempting to make a cell for my ledger balance i
need to figure out how to make it so that if the reconciled cell says no
then it will not be added to the sum.

Thank you for all of you help

William Storey II

William
A little hard to follow. Here is a general way to write an If formula
for something like what I think you want:
Say your reconciled cell is F1
If(F1="no",formula if No,formula if not no)
This says, in English, if F1 is "no" then use the first formula, if not, use
the second formula. HTH Otto
"William Storey II" <(E-Mail Removed)> wrote in message
news:LUQtb.31830$(E-Mail Removed)...
> Hello,
> I have a checking account ledger made with excel, pretty simple ledger.
My
> question is this i have a column right before the amount column that says
> reconciled (meaing that it has hit my statement online) the amount column
i
> enter it in either negative or positve and then i have a cell that says
> Available balance this i got by just using the sum of the amount column,
no
> my question is this i am attempting to make a cell for my ledger balance i
> need to figure out how to make it so that if the reconciled cell says no
> then it will not be added to the sum.
>
> Thank you for all of you help
>
> William Storey II
>
>