i have a sample date of three columns
100 20080130 100
200 20080120 100
300 20080120 200
400 20080130 100
500 20080110 300
300 20080110 200
200 20080115 100
100 20080115 200

the first col is amount; second is date and third is accountnumber
i want to have subtotals of each accountnumber sorted on date
how do i do this using excel?
i can do subtotalling for one col; not for two cols.

thanks, in anticipation