Excel Video Series Episode 8: CountIf
What if you wanted to count the number of cells that meet a specific criterion? For example, say I want to know how many people in Family Services answered the challenge question correctly. The easiest way would be to use the CountIf formula. Meaning “Count all the people who got it correct as long as they have the words Family Services in column A.”
Related Articles
Excel Video Series Episode 5: Formulas
In this video we look at how formulas work in Excel.
Excel Video Series Episode 4: Printing
In this video we will learn about Excel printing tips and tricks! Learn to change the layout and how to fit the whole page on a single sheet of paper.
Excel Video Series Episode 1: Intro
Over the past year I’ve had a few requests for Excel training. I LOVE Excel! It’s just such a MASSIVE program to teach that I’ve been trying to figure out where to start. Fortunately, I remembered you should always start at the beginning, so that is ...
Excel Video Series Episode 6: Text to Columns
I have a column of names (first and last) – but I really need to separate them into two columns, luckily, it’s a breeze with the text to column feature in Excel. Watch this quick video to learn the neat trick.
Excel Video Series Episode 7: Flash Fill
If I have two columns that I want to combine I can use this flash fill feature! This one was news to me, so I’m pretty excited about it. Excel can detect what you’re trying to do and hook you up!