Microsoft Copilot for Individuals | Complete Tutorial

Creating files is now faster and more streamlined with Gemini. ✨ #Shorts

This Excel tutorial shows a cool trick that you may not have known about! Did you know you can use wildcards with COUNTIFS to find partial matches? i.e., you can count the number of values that *contain* a word without the cell actually needing to equal a specific value The best part is that you can also do the same thing with SUMIFS! This method is very dynamic and powerful, especially when paired with a cell reference so you can easily and quickly update the cells you want to count #exceltips