Index and Match Functions

  • Thread starter Thread starter amirstal
  • Start date Start date
A

amirstal

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
Summing occurrences within a list 2
Another Running Totals Problem 9
CONCATENATE IF macro or function? 3
Is INDEX,MATCH the best way? 11
COUNTIF formula? 1
Access Report Incorrectly Summing Grouped Data 1
Match function / returning closest value in VBA 2

Back
Top