Want to do a SumProduct formula

S

Sam Commar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Output Date Grouping 1
Want to do sum by Acct Subacct 7
Display weeks from a Milestone 0
Find certain "Text" in a specific coloum, add corres. values 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
VBA word change keys 0
Case Sensitive SumProduct 4
Macro to generate FileName of the source file 1

Top