4 Best COUNTIFS Formula in Excel

It is an excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS may used with criteria based on dates, numbers, text, and other conditions. COUNTIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Note :-     This function Count cells that match multiple criteria

the number of times criteria are met.

Example Step :-

Range1 - The first range to estimate.

Criteria1 - The criteria to use on range1.

Range2 – {optional} The second range to evaluate.

Criteria2 – {optional}The criteria to use on range2.

Syntax :- 

=COUNTIFS (range1, criteria1, [range2], [criteria2], ...) Enter

Example :- = COUNTIFS((F7:F16,"Vikash Kumar",G7:G16,"Mouse") Enter

Example :- =COUNTIFS(H7:H16,">150")   Enter

Example :- =COUNTIFS(F7:F16,"Vikash Kumar") Enter

Note :- If you see example below deeply understand the formula. 

Example :- =COUNTIFS(F7:F16,"*Vikash Kumar*")   Enter