Autofill with the SUM of data when the same value is met in a separate column

[Pettor]

Hello guys,

I have a new project where I would like excel to autofill in the third column the sum of the second column when the value in the first column is the same.
i.e. When the value is A, the third column to get the sum of all the previous values of column B.

The different values in column A are thousands.

Is it possible? Is it possible also MS Access to do the same?

Many thanks

Values	Values	Auto Fill
A	1​	1​
A	0​	1​
B	1​	1​
B	0​	1​
A	0​	1​
A	1​	2​
C	1​	1​
C	0​	1​
A	1​	3​
B	0​	1​
B	0​	1​
C	1​	2​
C	1​	3​
C	0​	3​

 

[kevin9999]

Is this what you mean?

Book1
	A	B	C
1	Values	Values	Auto Fill
2	A	1	1
3	A	0	1
4	B	1	1
5	B	0	1
6	A	0	1
7	A	1	2
8	C	1	1
9	C	0	1
10	A	1	3
11	B	0	1
12	B	0	1
13	C	1	2
14	C	1	3
15	C	0	3
Sheet1

Cell Formulas
Range	Formula
C2:C15	C2	=SUMIF($A$2:A2,A2,$B$2:B2)

 

[Pettor]

Thanks you, let me test and I will revert

 

[kevin9999]

T

This could work for a limited number of values in column A but in my case there are thousands different values and new ones are added constantly. O need something that could work autonomously.

There's no reason why it wouldn't work with any number of different values. Try it and see.

 

[Pettor]

Thanks! Testing and I am coming back.

 

[Pettor]

My problem is that with this formula I get the same number in every row (column 3) while I would like to get the progressive sum, row by row (Column 4). Am I doing something wrong?

Thanks

Selection	Values	Formula	Desired
A	1,20​	5,11​	1,20​
A	-1,00​	5,11​	0,20​
A	0,95​	5,11​	1,15​
A	-1,00​	5,11​	0,15​
A	0,84​	5,11​	0,99​
A	-1,00​	5,11​	-0,01​
A	0,52​	5,11​	0,51​
A	1,27​	5,11​	1,78​
A	1,18​	5,11​	2,96​
A	0,65​	5,11​	3,61​
A	1,25​	5,11​	4,86​
A	-1,00​	5,11​	3,86​
A	-1,00​	5,11​	2,86​
A	3,25​	5,11​	6,11​
A	-1,00​	5,11​	5,11​

 

[kevin9999]

I can't see your formula, so I can't comment on whether it's correct or not. Make sure the first cell of the criteria and values ranges are absolute references, by which I mean (for example) $A$1:A1 and not A1:A1

 

[Pettor]

No, the formula works like a charm! It was my mistake! You are amazing! Does this work also in MS Access?

Many thanks!

 

[kevin9999]

No, the formula works like a charm! It was my mistake! You are amazing! Does this work also in MS Access?

Many thanks!

Glad I could help & thanks for the feedback. I know next to nothing about Access so unfortunately I can't help you there.

 

[Pettor]

Hi Kevin,

Is it also possible to be done, matching values from two columns? i.e. Column A has the name and column B has the surname, so when these two are the same to make the calculation?

Many thanks