Solved

Excel Summs

Posted on 2011-02-23
1
196 Views
Last Modified: 2012-05-11
I have an excel worksheet with multiple columns

I want sub totals in column TCV
for all the various status types in column status
0
Comment
Question by:Matt Pinkston
1 Comment
 
LVL 24

Accepted Solution

by:
broomee9 earned 500 total points
Comment Utility
Sort your workbook by the Status Column.

Then select all your data including the header fields
Click Data --> Subtotals

In the "At each change in" box select Status (if that's the name of your column)
In the "Add subtotal to" listbox, select your columns you want summed (T, C and V - they will be the name of the headers for those fields)
Click OK and that's it
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now