Index and Match Functions
I would like to know how I can use the index and match functions (or
any other functions) when pulling data from an table/array that is not
sorted (thus making vlookup unavailable).
For example:
A1 B1
Apples 100
Bannans 50
Apples 200
Oranges 300
Apples 357
Pears 400
Apples 3
How can I get the sum of all the apples?
Thanks,
Amir
|