Totals for Clients

[solarSEAL]

Hello, I need help with the excel worksheet I'm working on. I have a sheet with a list of clients in cell A and a number in cell B. Some clients appear more than once with numbers. I need to find the total of all the numbers for each client without doing this manually 1 by 1 because I have thousands upon thousands of clients.

For example:
Client A | 1
Client A | 2
Client A | 3
Client B | 2
Client B | 3
Client C | 1

I need a formula that will calculate the total for each client. Of course, I am using actual names and more complicated numbers this is just a simple example. Client A's total would be 6, Client B 5, Client C 1, and so forth.

Any help would be greatly appreciated, thanks.

 

[anandvarma]

try any of the two formulas

Excel Workbook
	A	B	C	D	E
1	Client A	1	Client A	6	6
2	Client A	2	Client A	6	6
3	Client A	3	Client C	1	1
4	Client B	2
5	Client B	3
6	Client C	1
Sheet1

 

[Aladin Akyurek]

Hello, I need help with the excel worksheet I'm working on. I have a sheet with a list of clients in cell A and a number in cell B. Some clients appear more than once with numbers. I need to find the total of all the numbers for each client without doing this manually 1 by 1 because I have thousands upon thousands of clients.

For example:
Client A | 1
Client A | 2
Client A | 3
Client B | 2
Client B | 3
Client C | 1

I need a formula that will calculate the total for each client. Of course, I am using actual names and more complicated numbers this is just a simple example. Client A's total would be 6, Client B 5, Client C 1, and so forth.

Any help would be greatly appreciated, thanks.

Some options...

1) Create a pivot table from the data.

2) Create a distinct list of clients on a separate location, e.g. using Advanced Filter.

Let A2:B7 house the sample you posted and E2:E4 the distinct list of clients.

In F2 enter and copy down:

=SUMIF($A$2:$A$7,E2,$B$2:$B$7)

3) Not recommended, anycase for a large set of data:

In C2 enter and copy down:

=SUMIF($A$2:$A$7,A2,$B$2:$B$7)