Excel Count Function – Count Excel Cells

The Excel Count function will count the number of non blank cells in a range. 
Select the cell where in you want the formula to be entered. (Cell B14)
Next Click on the Sigma  ∑ sign.  The drop down menu will give you a choice of functions – select Count.
The formula =Count(value1,[value2]….etc, highlite the section that you want to Count, hit Enter Key.
Or type the formula =count(B2:B13)  in the example shown below.

Excel07 CountFunction

Advertisements
Explore posts in the same categories: Excel - Helpful Hints & Tips

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

You can comment below, or link to this permanent URL from your own site.

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


%d bloggers like this: