Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

First question here. I'm a competent enough programmer but I'm wondering if there's an excel-like way to solve this. Lets say I have three columns: account #, date, expenditure. I want to see each accounts' expenditure via year. If I wanted to just see the gross total for all years per account, I know I could use the subtotal option. However, there doesn't seem to be an option to differentiate on more than one column (unlike the 'sort' function). What does SU recommend?

share|improve this question
up vote 1 down vote accepted

You can differentiate on more than one column in Excel. To do this, check each of your column names in the below window (under "Add subtotal to:"):

alt text

share|improve this answer
Thanks! Will come in handy. – jlv Nov 4 '10 at 13:13
You're welcome. – Mehper C. Palavuzlar Nov 4 '10 at 13:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.