sumproduct excel multiple tables
I have two tables and I want to count how many occurrences of an item by
referencing another table,
for example, I want to know how many snakes Bob owns, the obvious answer
is two but how do I do that in one formula? I have used sumproduct to
calculate the number of occurrences of individual snakes but I want them
all in one formula by referencing the second table. Is this possible?
Note: I have excel 2003, hence sumproduct
A B
1 Bob Boa
2 Ann Cow
3 Bob Sheep
4 Bob Python
A B
1 Farm Snake
2 Cow Boa
3 Sheep Python
No comments:
Post a Comment