 |
 | 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 / Links / March 2008Help?
I need some help on a checkbook register workbook that I am making. I have a column that is labeled as CATEGORIES which is a drop down list which contains.... "auto,household,medical,misc.. I want this register to be linked to a summary sheet which should show how much I spend in each category. Thanks! Sounds like a job for SUMIF. Suppose the list of categories is on the Summary sheet in A2:A20 and the register sheet is named Register and contains categories in column B and values in column C. In B2 in the Summary sheet put the formula =SUMIF(Register!B:B, A2, Register!C:C) and you should see the sum for the first item on the category list. Copy the formula down as far as B20. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Thanks Bill that worked like a champ. Thanks again. > Sounds like a job for SUMIF. > [quoted text clipped - 11 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup
|
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.