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

Index and Match Functions
 

If you want the SUM look in the help index for SUMIF

Vlookup does work with NON sorted by adding ,0 or ,false at the end.

--
Don Guillett
SalesAid Software

"amirstal" wrote in message
oups.com...
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