Forum Discussion
enter formula that counts and sums total for an individual
Hello I am trying to calculate a formula that counts a person's name and will calculate sum totals for that individual. But each item is located in a different column. Name is on one column, 2 ...
Ok this is what I am trying to complete. I hope you can understand me.
person Value1 Value2 Value3 Total person totalvalue1 totalvalue2 totalvalue3
A 2 16 3
A 3 15 4
B 2 16 4
B 2 22 2
B 2 13 3
B 3 10 3
B 2 16 3
B 3 11 3
B 2 19 2
C 1 16 1
C 2 31 2
C 2 18 2
C 3 22 2
C 4 10 3
C 3 11 3
D 3 6 2
D 3 12 10
D 2 9 6
D 5 13 4
E 2 7 4
E 1 3 1
E 2 5 4
person Value1 Value2 Value3 Total person totalvalue1 totalvalue2 totalvalue3
A 2 16 3
A 3 15 4
B 2 16 4
B 2 22 2
B 2 13 3
B 3 10 3
B 2 16 3
B 3 11 3
B 2 19 2
C 1 16 1
C 2 31 2
C 2 18 2
C 3 22 2
C 4 10 3
C 3 11 3
D 3 6 2
D 3 12 10
D 2 9 6
D 5 13 4
E 2 7 4
E 1 3 1
E 2 5 4
Does this return the intended result? Otherwise could you share your intended result?
=COUNTIF($A$2:$A$23,A2)This formula is in cell E2 and filled down.
=SUMPRODUCT(($A$2:$A$23=$A2)*B$2:B$23)This formula is in cell F2 and filled across range F2:H23.