Forum

Notifications
Clear all

Codes and their Sums

4 Posts
2 Users
0 Reactions
76 Views
(@meyanui)
Posts: 24
Eminent Member
Topic starter
 

Kind Regards,

Kindly provide a formula in column "F" to sum the amounts according to their codes.

Thanks in advance

 
Posted : 30/06/2018 6:10 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi

Please refer attachment.

You can use a formula or a Pivot Table.

Hope this helps.

Sunny

 
Posted : 30/06/2018 8:51 pm
(@meyanui)
Posts: 24
Eminent Member
Topic starter
 

Thanks very much Sunny. It worked.

Just that I'm not familiar with the option of Pivot Tables.

I am grateful.

 
Posted : 03/07/2018 11:12 am
(@sunnykow)
Posts: 1417
Noble Member
 

Thanks for your feed back. Glad we could help.

Use whichever method you feel comfortable with as long as you achieve your objective.

 
Posted : 03/07/2018 7:23 pm
Share: