Use Of COUNTIF Formula (Countif formula-ன் பயன்பாடு)

 

COUNTIF

 

          Countif formula-ஐ பயன்படுத்தி நாம் குறிப்பிட்ட எண்ணையோ அல்லது வாா்த்தையையோ எண்ணி பாா்க்கும் முறை

CRITERIA	FORMULA EXAMPLE	DESCRIPTION
Count if  greater than	=COUNTIF(A2:A10,">5")	Count cells where value is greater than 5.
Count if  less than	=COUNTIF(A2:A10,"<5")	Count cells with values less than 5.
Count if equal to	=COUNTIF(A2:A10,"=5")	Count cells where value is equal to 5.
Count if greater than or equal to	=COUNTIF(C2:C8,">=5")	Count cells where value is greater than or equal to 5.
Count if less than or equal to	=COUNTIF(C2:C8,"<=5")	Count cells where value is less than or equal to 5.
Count if  Text	=COUNTIF(C2:C8,”male”)	Count cells where value is equal to male