T
teresap10
I hope that someone can answer the 2 questions I have
I am trying to make a spreadsheet for my accounting, and this is what I am
looking for :
Question 1
We do not want to divide each of the columns into Debit and Credit, we are
hoping to have only one column for each heading and have the spreadsheet
know to add the debits and the credits separately and then place the totals
separately.
Is there a way that works can calculate (in one column ie : column D) all my
debit amounts and put the total in cell ie: D29 ....... then add all
the credits (which are indicated in red ) in Column D and put the total in
D30.
Question 2
I want to enter an amount in cell F29 I want that same figure to also be
entered automatically into cell AC19, is there a way that I can do that.
I have been working on these, looking for answers, and can't seem to find
anything, any help would be appreciated. Thank so much
I am trying to make a spreadsheet for my accounting, and this is what I am
looking for :
Question 1
We do not want to divide each of the columns into Debit and Credit, we are
hoping to have only one column for each heading and have the spreadsheet
know to add the debits and the credits separately and then place the totals
separately.
Is there a way that works can calculate (in one column ie : column D) all my
debit amounts and put the total in cell ie: D29 ....... then add all
the credits (which are indicated in red ) in Column D and put the total in
D30.
Question 2
I want to enter an amount in cell F29 I want that same figure to also be
entered automatically into cell AC19, is there a way that I can do that.
I have been working on these, looking for answers, and can't seem to find
anything, any help would be appreciated. Thank so much