I have an excel sheet wehre I have the followign coloums e.g below. I
wanted to get some kind of furmula or function that would let me do a sum
by every unique Acct\Subacct Combo

Acct Subacct DebitAmount CreditAmount
100 800 1000
100 800 4000
100 800 9000
100 1250 1400
100 1250 1600
100 1250 3000


So basically my sum would be

Acct Sub DebitAmount CrediAmount
100 800 5000 9000
100 1250 3000 3000

As there are thousands of lines I cant manually do this. I would apprecaite
if someone cas assist

Thanks in advance
Sandy