Take the 2-minute tour ×

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
add comment

1 Answer

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
add comment

Your Answer


