Is there formula what allows to count how many people have taken more than 10 days of holidays

%3CLINGO-SUB%20id%3D%22lingo-sub-1598795%22%20slang%3D%22en-US%22%3EIs%20there%20formula%20what%20allows%20to%20count%20how%20many%20people%20have%20taken%20more%20than%2010%20days%20of%20holidays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMby%20you%20can%20help%20me%3A%3C%2FP%3E%3CP%3EExample%20i%20have%20long%20list%20of%20people%20and%20how%20much%20they%20have%20taken%20holidays%20this%20week.%20Is%20there%20formula%20what%20allows%20to%20count%20how%20many%20people%20have%20taken%3CSTRONG%3E%20more%3C%2FSTRONG%3E%20%3CSTRONG%3Ethan%3C%2FSTRONG%3E%2010%20days%20of%20holidays.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1598795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598845%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20formula%20what%20allows%20to%20count%20how%20many%20people%20have%20taken%20more%20than%2010%20days%20of%20holidays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728067%22%20target%3D%22_blank%22%3E%40Gormowka%3C%2FA%3E%26nbsp%3BThat%20could%20be%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIF(%3CRANGE%3E%2C%22%26gt%3B10%22)%3C%2FRANGE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E....%20where%20%3CRANGE%3E%20is%20the%20list%20of%20holidays%20taken.%20%26nbsp%3B%3C%2FRANGE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

 

Mby you can help me:

Example i have long list of people and how much they have taken holidays this week. Is there formula what allows to count how many people have taken more than 10 days of holidays. 

 

Thank you

1 Reply

@Gormowka That could be 

=COUNTIF(<range>,">10")

.... where <range> is the list of holidays taken.