There are several different counting formulas in excel and they can sometimes get confusing which one you would use for a certain situation. Today we are going to review when you use each of the three main counting formulas which are COUNT, COUNTA, and COUNTIF.

First, COUNT is a formula used to count the number of cells that contain numbers. Below you can see an example of this formula that is using a list of numbers in excel. Cell A9 contains the formula that is counting all of the cells above it that contain a number in them.

Next, COUNTA is a formula use to count the number of cells that contain numbers or letters in them. Below you can see an example of this formula that is counting the number of cells that have names of fruits in them. Cell A11 contains the formula that is counting all of the cells above it with either letters or numbers in them.

Finally, COUNTIF is a formula used to count the cells based on one criteria, for this example we are going to count the number of cells that have a value greater than 9. Cell A9 contains the formula that is reporting the answer 2 because only two cells included in the formula are greater than 9. The cells greater than 9 have been highlighted in yellow.

Contact us today for information www.eagleeyebookkeepingservicesllc.com or to schedule a free consultation.

### Like this:

Like Loading...