# Formula for how much a customer bought something

#### nijsten8

##### New Member
Dear all

I'm looking for a way to calculate the sum of what customers bought

 Customer # D229 50 D190 60 D120 50 N003 1 N007 1 B053 5 B024 3 D190 2 N003 2 N007 3 B007 5 B003 2 B007 2 B053 5

<tbody>
</tbody>

For example, B007 bought 2 times (1 time 5 pieces, 1 time 2 pieces), in total 7 pieces. is there a formula to do this (quick)?

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Marcílio_Lobão

##### Well-known Member
nijsten8, Good morning.

Suppose:

A1:B100 --> Sales Table

D4 --> CUSTOMER ID

Try to use:

=SUMIF(A1:A100, D4, B1:B100)

Is that what you want?
I hope it helps.

Replies
2
Views
264
Replies
0
Views
406
Replies
3
Views
1K
Replies
3
Views
481
Replies
1
Views
256

1,191,717
Messages
5,988,262
Members
440,146
Latest member
rgomes8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back