If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel formula query

The Mighty Dubs · 2012-01-17 11:46:03

Hi, I have an excel with a list of entries and i want to get a list of totals. The list is something like this P00001 - 52 P00001 - 12 P00002 - 100 P00003 - 43 P00003 - 56 P00004 - 16 and so on. I need to be able to add all the duplicates and come back with a list like this e.g. P00001 - 64 P00002 - 100 P00003 - 99 P00004…

17-01-2012 11:46am

#1

The Mighty Dubs

Registered Users, Registered Users 2 Posts: 224 ✭✭

Join Date: November 2005

Posts: 126

Hi,

I have an excel with a list of entries and i want to get a list of totals. The list is something like this

P00001 - 52
P00001 - 12
P00002 - 100
P00003 - 43
P00003 - 56
P00004 - 16

and so on. I need to be able to add all the duplicates and come back with a list like this e.g.

P00001 - 64
P00002 - 100
P00003 - 99
P00004 - 16

Any ideas would be very very welcome.

0

Comments

#2 17-01-2012 12:13pm

TechnoFreek

Registered Users, Registered Users 2 Posts: 2,922 ✭✭✭

Join Date: March 2007

Posts: 2633

You could use a pivot table. It would appear in a second sheet though and not use formulas.

0
#3 17-01-2012 2:21pm

The Mighty Dubs

Registered Users, Registered Users 2 Posts: 224 ✭✭

Join Date: November 2005

Posts: 126

thanks for that. Thats the job

0