youtube SEO, tricks for blogger, wordpress tricks for earning money online youtube earning, whatsapp,windows, android & all about new technology.

Countif Function in MS Excel

No comments

What Does It Do ?
This function counts the number of items which match criteria set by the user.



  • The criteria can be typed in any of the following ways.
  • To match a specific number type the number, such as =COUNTIF(A1:A5,100)
  • To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello")
  • To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100")

  • Formatting

    No special formatting is needed.