Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: Adding Subtotals - Excel

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: Sat, Mar 14, 2020, 8:26 AM


Overview

This article outlines how to add subtotals to a rectangular range of data in an Excel spreadsheet

Procedure

1. Make sure your range of data is rectangular and has a heading for every column 2. Select any cell in your range of data 3. Sort your range by the column you want to group by 4. Data tab > Outline group > Subtotal

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.