Index Match and SUMIF

Hi peeps,

I need a index match AND sumif tutorial..

Literally idiot proof so when I receive list of data I know when to use the INDEX MATCH or SUMIF functions.

Please help me learn these two functions.

thanks

Sumif – I use this one a lot. Basically in a sheet you might have a list of clients all listed in a column and every so often you have a total for a group of them, lets say that it is a group that is one of the customer service reps handles. In column B it says total then in column C it is the invoice amount. With the SumIf you can set up a formula that says:

=sumif(B:B,”Total”,C:C)

This formula looks for the word “Total” in Column B and then sums all the numbers from Column C that correspond.

I really have not used Match at all. If I understand it correctly it is set up as:

=Match(“Value to lookup or find”, Range of cells to look in for value, Match_Type)

The match type will either find an exact match when you put in a “0”, or the next smallest if “1” is entered into the formula, if a “-1” is entered then the column being sorted on needs to be in descending order, not ascending. The positive “1” finds the same number or the next smallest, while the negative “1” finds the next largest number or value.

All the Match really does is give you a reference to where the information is, kind of like a Find, but the result can be used in a formula.

Index does something totally different. If you need this one explained as well or any of these further let me know.

Jake

hey thanks for your reply...

any chance of getting a working example of both SUMIF and INDEX MATCH, not just INDEX or MATCH...

thank you thank you

See attached. I am not sure about the Index Match, I have never heard of that one being combined. I have a few examples of the sumif and one example of Index and Match. I know you can combine an index search and a match search.