Excel Formula with example (Tutorial 1: COUNTIF and IFERROR)

How efficient are you in Excel? Do you take too long on Excel tasks and feel frustrated that you are doing one thing over and over?  Excel is one of the most efficient programs if you know how to apply Excel formulas to your tasks. You will be surprised at how powerful Excel can get when fed with the right formulas. Excel formulas are very useful in handling large data sets efficiently. The good thing is that these formulas are very easy to learn. To understand this better, it is good to practice on excel formula with example.

Top Excel Functions with Formula examples (Tutorial 1: COUNTIF & IFERROR)


The COUNTIF function is used to show how many times a certain value appears. The formula is written as;

How to:

=COUNTIF (range, criteria)

If for example, you have a list of 50 names and would like to see how many times the name John appears in column A, the formula would be;

=COUNTIF (A2: A50, “John”)

excel formula with example

If this formula were to be used for other columns, it would have to be manually changed every time for a new column. To avoid this, absolute references are made. This would be written as;

=COUNTIF ($A$2:$A$50, “$D11”) where D11 is the new cell it has been copied into.

Click here to read more on COUNTIF excel formula with example screenshots! (Count cells between two numbers using COUNIF formula)

What is IFERROR function

Though this function is not a common appearance in the list of Excel formulas, it is very useful in handling errors.  This function is used to avoid error messages. When Excel encounters an error, it will often show up as #VALUE!.  Other error messages that come up include are #DIV.  The IFERROR function is written as;

How to:

=IFERROR (condition/value, what result if condition/value is wrong).

If for example there is a division formula in C2 that is A2/B2, the IFERROR formula would be written as; =IFERROR (A2/b2, “Review”) to avoid an error message. The word ‘Review’ would show up when Excel encounters a difficulty in executing the division formula if for example there is a text value that cannot be divided.

Screenshot example and scenarios (to make it more simple to understand):

excel formula with example

Scenario 1. Direct division formula without IFERROR function

600/30 = 20 {Formula in C2 =A2/B2}

Scenario 2. Direct division formula without IFERROR function where value contains a text

600a/30 = #VALUE! {Formula in C3 =A3/B3}

Scenario 3. Division formula with IFERROR function

600/30 =20 {Formula in D2 =IFERROR (A2/B2,”Review”)}

Scenario 4. Division formula with IFERROR function where value contains a text.

600a/30 =Review {Formula in D3 =IFERROR (A2/B2,”Review”)}

Page 2 >>> Learn more Excel Formula with example: IF, SUM, SUMIF etc.

About Anson

I’m Anson having a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. asKeygeek.com is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema. In short, a Consultant by Profession! a Geek by Interest!! & a Filmmaker by Passion!!! 🙂

One Comment

  1. Pingback: Robotic Process Automation (RPA) – What Why How All you need to Know

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.