Forum Discussion
Mix between vlookup and sum command?
Hello, I am making an excel spreadsheet for my fiancé who is a first year teacher. She needs to report grades every 10 weeks. There are kids who are regular students (Denoated as ‘REG’). There are al...
It is better go with Sumifs with Index match function. Incase only two columns are there, you can for sumif with index match function. More than two columns better go for sumifs with index match function.
sumif with index match
=SUMIF(Range,Criteria, INDEX(Range,0,MATCH(lookup,Range,0)))
More than 2 columns to match
=SUMIFS(INDEX(Range,0,MATCH(Lookup value, search range,0)),Criteria range1, Criteria1, Criteria range2, Criteria 2)
Based on data, criteria 1 and 2 can be decided.
Thanks
sumif with index match
=SUMIF(Range,Criteria, INDEX(Range,0,MATCH(lookup,Range,0)))
More than 2 columns to match
=SUMIFS(INDEX(Range,0,MATCH(Lookup value, search range,0)),Criteria range1, Criteria1, Criteria range2, Criteria 2)
Based on data, criteria 1 and 2 can be decided.
Thanks