Subtotaling columns

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

At a class I went to the teacher showed us how to
subtotal columns across. Example: you have the 12
months and want to subtotal the quarters. This is just
like subtotaling the rows where you have the 1,2,3 in the
far left margin. You can click on the 2 to see the
subtotals of the rows or 1 to see the grand total. I
don't remember how to do it across the columns. Can
anyone help me?

Thanks!
 
You could insert columns to total the quarters, and a column to total
the year.
Then choose Data>Group and Outline>Auto Outline, and you'll see Outline
buttons at the top left of the worksheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Additonal info into newly created Subtotal row 1
Need array formula to ignore hidden values 1
Subtotals & Conditional Formatting Part 2 1
Getting Text data using the Data - Subtotal feature 1
calculating subtotals for sequential blank cells in 1 column 1
Nesting SUBTOTAL with SUMPRODUCT? 0
Autosum column values, if separate column values equal certain val 1

Back
Top