View Single Post
  #1   Report Post  
carrera
 
Posts: n/a
Default Adding numbers that meet a condition?

Hi
Here's a sample of colums a & B rows 10-14

House 4
Tenent 1
Lawyer 3
House 2
Lawyer 8

In column G rows 1-3 I have listed
House
Tenent
Lawyer

I would like column H, rows 1-3 to read
6
1
11
adding up the totals for each item listed from A & B

Thanks