# Summation problem

#### segran

##### Active Member
Hi All

I have the following table:

A 1
A 22
A 4
B 3
B 7
A 11
C 5
C 77
B 2
D 34
E 32
D 43
E 54

I wish to obtain the sum for all A, B, C, etc. The input of A's, B's, C's, etc will vary each time, the total sum is carried out...that is, how do I obtain respective sums for each, when I the input for each changes.

Your assistance would be greatly appreciated.

Thank You

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
segran said:
Hi All

I have the following table:

A 1
A 22
A 4
B 3
B 7
A 11
C 5
C 77
B 2
D 34
E 32
D 43
E 54

I wish to obtain the sum for all A, B, C, etc. The input of A's, B's, C's, etc will vary each time, the total sum is carried out...that is, how do I obtain respective sums for each, when I the input for each changes.

Your assistance would be greatly appreciated.

Thank You

=SUMIF(A:A,E2,B:B)

where E2 houses a criterion like A.

Replies
5
Views
388
Replies
14
Views
559
Replies
5
Views
375
Replies
7
Views
236
Replies
4
Views
203

1,203,047
Messages
6,053,197
Members
444,645
Latest member
mee siam

### 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