Posts

Showing posts with the label Countif Fourmula

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

Image
  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 ...