 |
 | 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 / Worksheet Functions / September 2007Consolidating Data
I have a 12,000 row spreadsheet that contain sales tax received by various businesses. One particular business may have 2 records or 20 records. Also, there are two types of sales tax which are all in the same field COMPANY NAME TAX TYPE AMOUNT X 1 3.00 X 2 4.00 X 2 1.00 Y 1 5.00 Y 2 4.00 How can I summarize this data where I can see what the totals are for each business for each tax type (preferably where the sum each tax type is in a separate field)  SignatureGator Try the SUMPRODUCT function: =SUMPRODUCT(--(A1:A12000="X"),--(B1:B12000=1),C1:C12000) HTH, Elkar > I have a 12,000 row spreadsheet that contain sales tax received by various > businesses. One particular business may have 2 records or 20 records. Also, [quoted text clipped - 9 lines] > business for each tax type (preferably where the sum each tax type is in a > separate field) like this...... COMPANY NAME TAX TYPE 1 TAX TYPE 2 X 3 5 Y 5 4 ....see below for part one of question SignatureGator > I have a 12,000 row spreadsheet that contain sales tax received by various > businesses. One particular business may have 2 records or 20 records. Also, [quoted text clipped - 9 lines] > business for each tax type (preferably where the sum each tax type is in a > separate field) ....Like this Off the FileMenu, try >Data>Subtotal and filter it accordingly. > I have a 12,000 row spreadsheet that contain sales tax received by various > businesses. One particular business may have 2 records or 20 records. Also, [quoted text clipped - 9 lines] > business for each tax type (preferably where the sum each tax type is in a > separate field) The Pivot Table works best SignatureGator > I have a 12,000 row spreadsheet that contain sales tax received by various > businesses. One particular business may have 2 records or 20 records. Also, [quoted text clipped - 9 lines] > business for each tax type (preferably where the sum each tax type is in a > separate field) |
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.