summing workhours of weeks

[Sorttaaja2]

How to count together all numbers from rows under column b that have same number in column a? (like 20 would be 1+4+2= and 25 3+6+7= ) List is long and would be nice to do this automatically.


a=week nr , b=work hours


a,b
--
20,1
20,4
20,2
23,3
24,3
25,3
25,6
25,7


thankyou!

 

[FormR]

Hi, sounds like you want SUMIFS() - for example:

Excel 2013/2016
	A	B	C	D	E
1	WEEK NR	HOURS		WEEK NR	TOTAL HOURS
2	20	1		20	7
3	20	4		23	3
4	20	2		24	3
5	23	3		25	16
6	24	3
7	25	3
8	25	6
9	25	7
Sheet1

Cell Formulas
Range	Formula
E2	=SUMIFS(B:B,A:A,D2)