Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX and MATCH functions | Excel Worksheet Functions | |||
Index and Match functions I think | New Users to Excel | |||
INDEX & MATCH functions | Excel Worksheet Functions | |||
Index and Match Functions | Excel Worksheet Functions | |||
How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions |