Free EXCEL Tutorial for Beginners

   COUNTIF Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used  COUNTIF FORMULA What Does It Do ? This function counts the number of items which match criteria set by the user. Syntax = COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched) 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.  BACK TO HOME PAGE If You Want free Stuffs or Products check our   For More Offers  SUBSCRIBE US    https://excelknowlegde.blogspot.com To Support US  Donate Now

   COUNTBLANK Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used  COUNTBLANK FORMULA What Does It Do ? This function counts the number of blank cells in a range. Syntax '=COUNTBLANK(RangeToTest) Formatting No special formatting is needed. Example The following table was used by a company which was balloting its workers on whether  the company should have a no smoking policy. Each of the departments in the various factories were questioned. The response to the question could be Y or N. As the results of the vote were collated they were entered in to the table. The =COUNTBLANK() function has been used to calculate the number of departments which have no yet registered a vote.

   COUNTA Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used COUNTA Formula What Does It Do ? This function counts the number of numeric or text entries in a list, "COUNT" function only counts the numeric entries only. It will ignore blanks. Syntax = '=COUNTA(Range1,Range2,Range3... through to Range30) Formatting No special formatting is needed. Example The following table was used by a school to keep track of the examinations taken by each pupil.  Each exam passed was graded as 1, 2 or 3.  A failure was entered as Fail. The school needed to known how many pupils sat each exam. The school also needed to know how many exams were taken by each pupil. The =COUNTA() function has been used because of its ability to count text and numeric entries. BACK TO HOME PAGE If You Want free Stuffs or Products check our   For More Offers  SUBSCRIBE US    h...

   COUNT Check below example and try to use in excel in real time for better understanding B lue text start with "=" is the formula we used    COUNT FORMULA What Does It Do ? This function counts the number of numeric entries in a list. It will ignore blanks, text and errors. Syntax =COUNT(Range1,Range2,Range3... through to Range30) Formatting No special formatting is needed. Example The following table was used by a builders merchant to calculate the number of sales  for various products in each month.