The Subtotal Button for Summarizing Data in an Excel Database

John O. Mason
Additional contact information
John O. Mason: Culverhouse School of Accountancy, The University of Alabama, Alabama, U.S.A.

Journal of Knowledge Management, Economics and Information Technology, 2011, vol. 1, issue 7, 10

Abstract: The subtotal feature in Excel allows you to generate summary information, such as subtotals, averages, record counts, and maximum and minimum values for groups of records in a database. When you generate the summary information, Excel adds summary and grand total rows to the worksheet, labels each row, and outlines the records in each group. By clicking on the outline minus and plus symbols, you can quickly hide and show the details for each summarized group of data. The subtotal feature also allows you to remove and replace summary information.

Keywords: Filter a database; Inserting summary information; Multiple sets of summary information; Replace current subtotals; Remove and replace summary information; Sort a database; Subtotal button; Subtotal feature; Subtotaling a subset of the database; Summary information (search for similar items in EconPapers)
Date: 2011
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.scientificpapers.org/download/109/ (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spp:jkmeit:1217

Access Statistics for this article

More articles in Journal of Knowledge Management, Economics and Information Technology from ScientificPapers.org
Bibliographic data for series maintained by Adrian Ghencea ().