How to conditionally count numbers in rows and columns - Microsoft Community

have spreadsheet h14:h475 contain text/numbers. of them repeats. need identify unique text/numbers; , sum respective row's column p value. i'm looking identify total of column p given unique value in column h.

for example:

given:

h14: ah-tc/2

h15: ac-p0

h16: 03b/a b6

h17: ah-tc/2

h18: ah-tc/2

h19: 13456

h20: joe l

p14: 8

p15: 11

p16: 1

p17: 4

p18: 4

p19: 0

p20: 10

the answer 16 ah-tc/2; has total of 16 in column p. need create new column pulls unique combinations have repeats in column h, column h. new column have each unique value column h , totals numbers in column p each time appeared in column h. appreciated!

select cells h14:p475 (and row 13 well, if headers there), , use insert / pivot table.  then drag header of column h row area, , header of column p data area, , set function sum.  and you're done.

Office / Excel / Windows other / Office 2016