Excel – Saturday

Saturday Excel

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.

Count

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.

COUNTA

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.

COUNTIF

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

Advertisements
This entry was posted in Excel.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s