Hi Sansy
I insist that you try doing this with a Pivot table. Far faster, easier and
more reliable. See
http://www.cpearson.com/excel/pivots.htm
HTH. Best wishes Harald
"Sam Commar" wrote in message
...
I have the following coloums in my Excel sheet. I have close to 30000
records and this will be an ongoing monthly process that I will need to do.
My data has 5 coloums from A to E
The 5 coloums of data are as below
A B C D E
Acct Subacct Project DebitAmt CreditAmt
I was trying to use a SumProduct formula to do do the Totals of the
DebitAmt and the CreditAmt by each distinct
Acct Subacct Project combination.
I have used the Advanced filter so that now in Coloum F G H have the
distinct Acct Subacct Project combinations.
Can I bother you to please guide me that once I have the distinct
Acct Subacct Project combinations in Coloum F G H- how can I get the sum
of the debitamt and creditamt amounts for each Acct-Subacct-Project
combination.
Sandy