Excel UNIQUE values Summing using COUNTIF + MAX + INDEX + MATCH + SUMIFS Formulas

Hey Excellers!

In this video I'll show you how to use a combination of Tables and
the COUNTIF,INDEX and MATCH formulas to determine the first instance
of a Sales Country in a Sales Table and then use it to Sum the
Sales for each country.

It teaches you a smart COUNTIF/MAX function formula trick to determine the first instance of a duplicate in a list and turn it into a sequence number which in turn can be fed into the MATCH formula which in turn is fed into the INDEX formula for Unique values and their sum of sales using SUMIF.

Hope you find this tip useful and can apply it to your work.

LIKE - SUBSCRIBE - SHARE - COMMENT - ENJOY!