RichCowell
Board Regular
- Joined
- Dec 5, 2013
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
Hi All,
I've got 2 columns of data, and need to add the numbers in column B for all the instances of specific terms in column A.
e.g.
So I have a list of unique values of the A column in another area, and I need to be able to display the SUM of all the instances of that person - so display 35 for Jo rather than 20 or an error.
Can anyone help? This must be possible, surely?
I've got 2 columns of data, and need to add the numbers in column B for all the instances of specific terms in column A.
e.g.
![6DGmFAv.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2F6DGmFAv.jpg&hash=c97261aa76d334ec52043a01063c7c59)
So I have a list of unique values of the A column in another area, and I need to be able to display the SUM of all the instances of that person - so display 35 for Jo rather than 20 or an error.
Can anyone help? This must be possible, surely?