32,208 views
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this free Excel video lesson, we will learn how to use Cont.se and Cont.ses in Excel to Count with Criteria in the spreadsheet with a Practical Example to help you in your Day to Day and in the job market to automate tasks and automate processes in Excel and also to perform analyses, create reports and find important results from a database in an Excel spreadsheet. The Excel cont.se formula counts the values that exist within the selected range in the Excel table that meet a specific criterion. For example, let's say you want to count how many times a certain word appears in a list or how many times a specific word is repeated in Excel how many times a product An item A barcode A city A specific region appear in an Excel spreadsheet You can use the cont if function to help you with this. The cont.ses function is very similar to the cont.se function, but the difference is that here we can use several Count criteria, we can use several different conditions and in this way we can perform more complex and specific analyses in Excel. For example, let's say you want to point out the number of orders that exist for a certain region, you can use the cont.ses function to help you solve this problem. Basically, the Count function in Excel counts how many times a specific text is repeated in the Excel table. And it is you who determines which criteria is used, which is the condition you want to use. #ExcellentJoão #Excel #Dashboard