Use the Countif () Function to find out how many name tags have been claimed / not claimed

This video lesson is in response to a viewer who is creating name-tag labels for an event. The question is, what Excel functions tells you how many labels have been claimed and how many remain.

Use the =COUNTIF() Function for this - it is easy to use. Much easier than trying to "nest" =IF() functions.

I also show you how to "Filter" the list to see exactly who has claimed their name tags - and how has not yet done so.

For the past six months I have been filming and editing two new instructional DVDs. "The 50 Best Tips for Excel 2007" has been selling briskly. "The 50 Best Tips for PowerPoint 2007" will be released soon.

Thank you for your continuing interest in my videos!

Danny Rocks
www.thecompanyrocks.com/excels

Category:

Howto & Style

Tags:

• Microsoft
• Excel
• 2007
• Functions
• COUNTIF
• FILTER
• Tutorial
• Lessons
• Named
• Ranges
• in
• Formulas

[akashakelly]

Wow you do rock excel! This was perfect. Thanks so much!

[DannyRocksExcels]

@akashakelly

Thank You! I am delighted that you found this helpful.

I am just getting back to posting some fresh Excel 2007 training videos.

Danny Rocks

[tirathmistry]

welcome Back Danny

I am Glad to Visit your Tutorials Again

Your tutorials are just great & valuable for Me & all Learner of Excel.

Keep posting your Excel Golden Tips always.There's so much to be learned from your tutorials. Anyone offering their skills is appreciated, and none are better than yours.

Keep up Good work man

God Bless you :-)