|
When reviewing a list of entries, sometimes it's helpful to quickly count how many of your cells contain text. For example, when collecting a list of potential attendees to an event. To do this, click into an empty Cell where you want the result to be displayed. Then enter: =Countif(A2:A25,"*"). This function will know that you want Excel to review all Cells from the range of A1 to A25, look to see which Cells have an entry of any time, and with the count these to result in a total number of signed-up attendees. 
0 Comments
Leave a Reply. |
About My BlogWelcome. I'm a admittedly a bit obsessed with how software can, and should, make our lives easier. But, to round things out, I'm also interested in the Arts, all kinds of Crafts, Cooking, Gardening, Bird Watching, Feeding the Squirrels and cool Business ideas. Thanks for visiting.
GS Software Consulting.ca
Visit:
www.gssoftwareconsulting.ca to view Course Outlines 
Join me in my guided learning journey series of online, Zoom-delivered, All-in-One foundational Courses & Targeted-Skills Courses with advanced topics. Instructor-led, Fast-tracked, Online Microsoft Office Training.
All Courses start with a concepts presentation followed by a hands-on try-out session brought together with a real-world practice lesson. Learn the most needed and most used software skills and receive a free 1-pager Skills Guide for quick reference. Find out more by visiting my GS Software Consulting.ca website or email me with any questions. Archives
January 2025
Categories
All
|