Lookup Week: Video 3 - SUMIFS, COUNTIFS, SUMPRODUCT
This is the third video of week 2 - lookup week - of our Excel Battle Training video series!
Today I'm introducing SUMIFS, COUNTIFS and SUMPRODUCT, and explaining why SUMPRODUCT (one of my very favourite functions) has lost much of its unique value.
Make sure you download the free workbook I'm sharing and referring to throughout this series:
https://drive.google.com/drive/folder...
Enjoy!