Summing/Totaling transactions with same account numbers.

[Dwayne35]

Hello,

I am hoping you can help.

I have two columns:

1st Column is Account Numbers (Some which are the same)

2nd Column number of Transactions

I need to get a sum or total number of transactions based on Account Numbers, with some account numbers listed multiple times.

`

Account Number Transactions

76012896 10

76012896 76

76012896 44

76012946 15

76012947 12

76012947 90

76012954 25

‘

 

[shrivallabha]

Hi Dwayne,


Welcome to Chandorg.


Your requirement can be completed in many ways which should make you happy. Examples would be:

1. Using Pivot Table.

2. Using Advanced Filter and SUMIF formula.

3. VBA macro.


Feel free to search this site for threads that match your needs. If you still have some problem get back to us.

 

[Dwayne35]

Can you tell which of these ways would be easiest? I am a novice Excel User and I have not tried any of these. I had a task assigned to me for work and I am unsure where to start.

 

[shrivallabha]

So you want me to judge it for you?


Search for the first two options [Leave VBA macro aside] and then see if you can work any one of them out on your own. Don't worry, simply try. Feel free to come back.

 

[Faseeh]

Hi Dwayne35,


If you want total number of times transaction is made from/to an account use:

=SUMPRODUCT((A1:A1000=76012896)*1)


If you want sum of transactions made from/to and account.


=SUMPRODUCT((A1:A1000=76012896)*(B1:B1000))

Regards,