Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Calculations in one column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Calculations in one column
1. Simply enter your debits as positive amounts, and your credits as
negative amounts. You sum the debits using: =sumif(D:D,"0") And credits as: =sumif(D:D,"<0") 2. In AC29, enter the formula: =F29 Regards, Fred "teresap10" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Calculations in one column
It Works1!!!!
Thanks you so much Fred I have spent numerous hours trying to find how to do this "Fred Smith" wrote in message ... 1. Simply enter your debits as positive amounts, and your credits as negative amounts. You sum the debits using: =sumif(D:D,"0") And credits as: =sumif(D:D,"<0") 2. In AC29, enter the formula: =F29 Regards, Fred "teresap10" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Calculations in one column
Maybe I spoke to soon,
for the first question I am getting error now that says "This function is not a valid works function" I am using vista home premium 64 bit, with works 9 any other ideas........... questions 2 works great. thats a help in itself. "teresap10" wrote in message ... It Works1!!!! Thanks you so much Fred I have spent numerous hours trying to find how to do this "Fred Smith" wrote in message ... 1. Simply enter your debits as positive amounts, and your credits as negative amounts. You sum the debits using: =sumif(D:D,"0") And credits as: =sumif(D:D,"<0") 2. In AC29, enter the formula: =F29 Regards, Fred "teresap10" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Calculations in one column
Sorry, I don't have Microsoft Works. This is an Excel newsgroup. To get help
with Works, you need to post to their group. Regards, Fred. "teresap10" wrote in message ... Maybe I spoke to soon, for the first question I am getting error now that says "This function is not a valid works function" I am using vista home premium 64 bit, with works 9 any other ideas........... questions 2 works great. thats a help in itself. "teresap10" wrote in message ... It Works1!!!! Thanks you so much Fred I have spent numerous hours trying to find how to do this "Fred Smith" wrote in message ... 1. Simply enter your debits as positive amounts, and your credits as negative amounts. You sum the debits using: =sumif(D:D,"0") And credits as: =sumif(D:D,"<0") 2. In AC29, enter the formula: =F29 Regards, Fred "teresap10" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multipule calculations in a single column | Excel Worksheet Functions | |||
How to do calculations with Null in the column? | Excel Discussion (Misc queries) | |||
Percentage calculations from an unsorted two column list | Excel Discussion (Misc queries) | |||
end of column refence in several calculations | Excel Discussion (Misc queries) | |||
formula to sum all sum calculations in a column | Excel Worksheet Functions |