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
|