This is a more advanced Excel tutorial on how to incorporate wildcards into your COUNTIFS function for more complex analysis. In this video I also show how to count values that are greater than or less than a certain number, which has a tricky syntax in COUNTIFS! #Excel #data #analyst #datascience #exceltips 💻 | Excelwithkyle23

32K views · 269 reactions | In this tutorial, I wanted to show a hidden trick that can make your Pivot Tables really powerful in Excel! Lots of people don't know about this, but you can count Unique/Distinct values in your Pivot so you don't have to create formulas like COUNTIFS or COUNT(UNIQUE)! This can make your analysis much easier and cleaner, while having your output all in 1 place #corporate #DataScience #BusinessGrowth #financetips #exceltips | Excelwithkyle23 | Facebook

Count not equal to multiple criteria

Unique values with multiple criteria

Count If Multiple Criteria Excel and Google Sheets