Alice Bumgarner, editor of Administrative Professional Today and contributing writer for Executive Leadership, has been writing about workplace and family issues for 13 years. Her articles have appeared in dozens of publications, including Salon.com, MSN.com, Continental magazine, Southern Living and Town & Country. She lives in Durham, N.C., with her husband, two daughters and dog Milo.
Question: “I need help writing an Excel formula that counts information from two columns. I want the result to be the total number of items that meet two conditions.
“Example: Imagine a spreadsheet where Column A records location and Column B records a number. I want to calculate how many entries for Location Such-and-Such also have a number in Column B that is less than 15 [=COUNTIF(B1:B25,”<15”]. How would I write that formula?” — Valerie
{ 0 comments }
17 Team Building IdeasTeamwork At Its Best: Training handouts to build a thriving team at workOvertime Labor Law: 6 FLSA compliance tips10 Time Management Tips: A how-to guide12 Ways to Optimize Your Employee Benefits ProgramWorkplace Violence Prevention ToolkitBest-Practices Leadership:Team Management tips10 Secrets to an Effective Performance Review: Examples and tipsPerformance Review DocumentsHow to Write Meeting MinutesStandard Operating Procedure: An example manualMinute Taking Template and Sample Meeting MinutesThe Office Organizer: 10 tipsOffice Organization Documents: 5 essential formsRecord Retention Schedule: Guidelines for every office documentMaternity Leave Laws: 7 guidelinesEmployment Background Check GuidelinesFMLA Intermittent Leave: 5 guidelinesFMLA Sample PolicyHow to Fire an Employee the Legal Way: 6 Termination GuidelinesThe Essential Employee Handbook14 Tips on Business EtiquetteOffice Communication Toolkit: 10 tips for managersWorkplace Conflict Resolution: 10 ways to manageSalary Negotiating 101: 7 secretsMicrosoft Excel Help: Excel Tips for Every Skill Level
Microsoft Email Outlook: Tips and Training
Tip Card: Microsoft Office Keyboard Shortcuts
Tip Card: Business Management Daily's Favorite Keyboard ShortcutsThe Bully Boss Strikes Again!Small Business Tax Deduction Strategies
