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 cells that contain text

Count cells that contain specific text

Master counting cells with text in Excel: A Complete Guide

How to Use Multiple Criteria in Excel COUNTIF and COUNTIFS

Count If Multiple Criteria Excel and Google Sheets

COUNTIFS with multiple criteria and OR logic