Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel worksheets
How can I enter dollar amounts on one worksheet by account name or number and
have them total on another worksheet. These amount entered on worksheet one would be either positive or negative dollar amount and reflect the totals on another worksheet by the entries from sheet one. I bacially need to have information keyed on one worksheet and have this information transfer to worksheet two and then sort by name or account number, and then add or subtract in each group of number and give a subtota for each group. |
#2
|
|||
|
|||
You need a SUMIF, that's all.
http://www.officearticles.com/excel/... oft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "BobbieJ" wrote in message ... How can I enter dollar amounts on one worksheet by account name or number and have them total on another worksheet. These amount entered on worksheet one would be either positive or negative dollar amount and reflect the totals on another worksheet by the entries from sheet one. I bacially need to have information keyed on one worksheet and have this information transfer to worksheet two and then sort by name or account number, and then add or subtract in each group of number and give a subtota for each group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Appending excel worksheets | Excel Worksheet Functions | |||
In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) |