Hi there!

I completely agree with you that SUMPRODUCT is a powerful function that can replace SUMIF and COUNTIF. It allows you to use multiple criteria to sum or count a range of cells. And the best part is that it doesn't require you to use an array formula like SUMIFS or COUNTIFS.

As for INDEX/MATCH, it's a great alternative to VLOOKUP, HLOOKUP, and LOOKUP. It's more flexible and efficient than VLOOKUP, especially when dealing with large datasets. With INDEX/MATCH, you can look up values in any column and return a value from any other column in the same row.

Here's an example of how to use INDEX/MATCH:

1. Let's say you have a table with customer names in column A and their corresponding sales figures in column B.
2. You want to look up the sales figure for a specific customer, "John Smith".
3. Instead of using VLOOKUP, you can use INDEX/MATCH like this:
   
   Formula:

   =INDEX(B:B,MATCH("John Smith",A:A,0)) 

4. This formula will return the sales figure for "John Smith" from column B.

I hope this helps you discover the power of these amazing formulas!