COUNTIFS FUNCTION
Gửi ngày 26 tháng 6 năm 2017

Summary 
The Excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS can be used with criteria based on dates, numbers, text, and other conditions. COUNTIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Purpose 
Count cells that match multiple criteria
Return value 
The number of times criteria are met
Syntax 
=COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
Arguments 
Range1 - The first range to evaulate.
Criteria1 - The criteria to use on range1.
Range2 - [optional] The second range to evaluate.
Criteria2 - [optional] The criteria to use on range2.

Print In tin
Download CTIM - Diễn Đàn Tin Học CTIM