#1   Report Post  
Old June 28th 05, 05:59 AM
BobbieJ
 
Posts: n/a
Default 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   Report Post  
Old June 28th 05, 06:55 AM
Anne Troy
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending excel worksheets Rbuzard Excel Worksheet Functions 3 September 13th 05 11:57 AM
In Excel combine tables from multiple worksheets in to one sheet? Pau Excel Worksheet Functions 1 June 25th 05 12:31 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
How to send Excel 2000 worksheets to Excel 2003? SecretarybyBarry Excel Discussion (Misc queries) 2 February 21st 05 06:28 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017