ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel worksheets (https://www.excelbanter.com/excel-worksheet-functions/32768-excel-worksheets.html)

BobbieJ June 28th 05 05:59 AM

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.

Anne Troy June 28th 05 06:55 AM

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.





All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com