0
A COUNTIF can only have one criteria. What you could do is use four COUNTIF functions in one formula and add them together. So say that you wanted to find the single total of four different names in a list, you could do it like this:
=COUNTIF(A3:A200,"John")+COUNTIF(A3:A200,"Tim")+COUNTIF(A3:A200,"Bob")+COUNTIF(A3:A200,"Ronnie")
If the criteria are combined, rather than searching for four different things, you could use IF with the AND and/or the OR function to first work out if something meets your 4 criteria and put the result in a new column. If it meets all 4 criteria you could put 1 in that cell otherwise 0. Then you could count the amount of times 1 appears on that column with a normal COUNTIF function, or even SUM up all the values and you would also get the total. If you have Excel 2007 or higher, there is a COUNTIFS function which can deal with multiple criteria.
What else can I help you with?
4 criterias in staffing human resouce management?
the four 4 criterias in staffing is involves job analysis,resouce planning,human resouce planning,recruitment and selection...
What is an example of a quadrilateral?
__ /__\<- Here is an example of a quadrilateral. All it needs is four connecting sides and four angles. Hence, quad= four.
What are examples of the four major macromolicules?
The four major macromolecules are carbohydrates (example: glucose), lipids (example: triglycerides), proteins (example: enzymes), and nucleic acids (example: DNA).
What is an example of four significant figure?
15.44
Is four an abstract noun?
The noun 'four' is a concrete noun as a word for a physical count of something (for example: The apples look good. I'll take four.)The noun 'four' is an abstract noun as a word for a count of something abstract (for example: We finished the project on day four.)
What is an example of 4 syllable celebrities?
An example of a four-syllable celebrity is Leonardo DiCaprio. Another example is Jennifer Aniston. These names consist of four distinct syllables, making them fit the criteria you specified.
What is sixty four plus four equal to sixty four plus four an example of what property?
Commmunative property--check in your math books it should be in there
Can you give an example of a verbal model?
three plus four is tree times twenty-four.
All dogs have four legs Rover is a dog Rover has four legs This is an example of?
syllogism
What is the plural of soul?
souls. Example: There were four men at the table; therefore, there were four souls at the table.
Babies laughing at four months is an example of?
develoment:)
What is a four-sided regular polygon?
A square for example.
