5 Must-Know Excel Formulas: SUM, INDEX, MATCH, SUMIF, SUMIFS

[@martinmaison6421]

Very useful
=SUMIFS(INDEX(entire table,,MATCH(sum results column heading name, entire Heading column )), criteria 1 vertical column, target criteria, criteria 2 vertical column, target criteria, 3 vertical column, target criteria, 4 vertical column, target criteria)

[@notanaive]

Thank you so much but the background music doesn't allow to hear you well and be concentrated.

[@SimpleSheets]

Thank you for the feedback! We'll lower the background music so it's easy to concentrate in future videos :)

[@ntnsty]

ah, the music! can't do it

[@AdrienneDiRosario]

Using music with words makes it impossible to understand what you're saying

[@SimpleSheets]

Noted, thanks for your feedback!

[@hamzasenhaji4154]

not very well explicated and you go so fast that we can't follow.

[@SimpleSheets]

Thanks for the feedback!