Hellow guys, Welcome to my website, and you are watching How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before). and this vIdeo is uploaded by Leila Gharani at 2020-03-05T02:00:08-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 05-03-2020 05:00:08 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses In this video you'll learn about a super short formula in Excel to count cells with text and ignore blank cells, numbers and also formula cells that result in blank cells or empty strings. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/count-text-file This is one of a kind Excel formula hack. I received this special syntax for the Excel COUNTIF function from Jack, one of our community members. It works perfectly although I have no idea why. Because it looks like we are applying a wrong Excel syntax (angry eyes). If we were to write the formula "correctly" it would only exclude the truly blank cells. But cells that include formulas which result in blank cells would still be included in the count. Alternatively, we can use the Excel COUNTIF function with the placeholders ? and *. This Excel count formula which uses wildcards, will also also just count non blank cells and ignore formulas that result in blank cells as well as ignore zeros and other numbers. In a situation when we want to count all cells that include either text or numbers we can use SUMPRODUCT in combination with the LEN function. This way we can check if the length of the content in the cells is at least 1 character. You can replace SUMPRODUCT with SUM if you have the new Dynamic Array Excel - if you have legacy Excel and use SUM instead of SUMPRODUCT you need to press Control+shift+enter. Key Insights: - Rare Excel Syntax Discovery: Unearth a special syntax in Excel formulas that might have escaped even seasoned Excel users. Learn about a formula technique that's not commonly known. - Contextual Challenge: Understand the practical challenge of counting text values in Excel, excluding numbers, blank cells, and formulas resulting in empty strings. - Formula Demonstration: Watch as we test this unusual formula, achieving accurate text counts and excluding non-text elements. - Alternatives Explored: Compare the mysterious formula with more traditional methods like wildcard characters in the COUNTIF function and the versatile SUMPRODUCT formula. - Practical Application: See how these formulas can be applied in real-world scenarios, enhancing your data analysis and Excel efficiency. 00:00 How to Count Text Cells in Excel 02:07 Excel formula hack to count text cells 02:52 Alternate Excel formula to count text cells (with wildcards) 03:49 Count all cells except the truly blank cells in Excel 04:30 Count all text cells and numbers but exclude blank cells and formulas that result in blank cells Excel hacks and tricks playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Excel hack | excel office 365 | office 365 | Excel formula hack | excel trick | excel countif function | count text in excel exclude blanks | excel count ignore zero | excel count cells with text | excel count non blank cells ignore formula | countifs not blank | countif | angry eye |
