 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2004Adding Numbers on 1 Column based on the Value of another Column
Hey Everyone, I am creating a budget sheet for myself. One of the columns is "credit" or "debit" and another column is the amount. What I am looking to do is tally up all the credits and all the debits in 2 separate cells. What is the best way to go about this? Best wishes, Jonas =SUMIF(range,criteria,sum_range) =SUMIF(A1:A100,"Credit",B1:B100)  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Hey Everyone, > [quoted text clipped - 6 lines] > > Jonas Thanks Ken! > =SUMIF(range,criteria,sum_range) > [quoted text clipped - 15 lines] > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004 You're most welcome :-) SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.