Takeaway: In this week’s Office Challenge, Susan Harkins tests your Excel skills by creating a dynamic counting function. Can you meet the challenge?
Using the sheet shown below, how would you count the number of personnel not meeting their quota? Right now, there is no quota stated, that’s up to you. There’s more than one way to solve this one and it isn’t as difficult as you might think. Right now, the sheet counts the sales per person using the following formula:
=COUNTIF(Sales[Personnel],B1)
Credit will go to the easiest solution and the solution that incorporates the existing components the best.
Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
No messages found
No messages found
Log in to display your contacts' posts.
Once logged in, adding contacts is simple. Just mouse over any member's photo or click any member's name then click the "Follow" button. You can easily manage your contacts within your account contacts page.
