1. Computing
Excel Spreadsheet COUNT Function
Excel Spreadsheet COUNT Function
© Ted French
Excel’s COUNT function is one of a group of well used “Count Functions” that can be used to total the number of cells in a selected range in a spreadsheet.

All of the functions in this group perform different tasks. What the COUNT function does is total all of the cells in a range that contain numbers. It will ignore blank cells and those containing text.

So if you need to know how many cells contain numbers or dates in an Excel spreadsheet the COUNT function will do the job for you.

To find out the details about using this function in a spreadsheet, read the article on the Excel COUNT Function.

Related Articles
Comments
August 16, 2012 at 10:19 am
(1) Kevin Mooney says:

Hi,

I am trying to build a formula to count the number of instances that a person is sick. For example, if I was sick for 3 days in a row for 8 hours each day and then sick 2 months later for 8 hours, I would like to count this as two instances. In other words, if the cells have consecutive values I want it to count that chain as 1.

8,8,8,0,0,0,8 = 2

thanks,

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.