How to count the number of cells containing numbers

Very often we are required to find the count of cells in a range that contain numbers. Like in the below mentioned example we have  shown the quantity sold against the names of the each sale.

Now since we have the serial numbers mentioned against each sale so we can easily tell how many sales were done. But in case we did not have the serial number the how would we find out how many sales happened, well we can do that using the COUNT FORMULA.

The COUNT FORMULA would be used to count the number of cells which have a number mentioned in the sales column like shown in the example below

Now in the example we have selected column F to find the number of cells containing numbers, what would happen if we selected column E also which has the names of the fruits sold?

We would still get the same answer! Why, because the COUNT FORMULA only counts the cells the cells containing numbers and ignores other cells. See example below

The count formula works for cells containing numbers vertically, horizontally or both i.e. a range as shown in the example below 

How to apply the Count Formula

Just select the range for which you want to the find the count of cells containing cells and type

=count (cell range)

That it so simple J

You can also a video tutorial on the COUNT FOMULA here

• English video http://www.youtube.com/watch?v=0_rS1AJMje4
• Hindi Video http://youtube.com/watch?v=uU1mybz2pAQ

To download the training files please visit www.myelesson.org

How To Use Vlookup In Excel

             How To Use Vlookup In Excel

Hi and welcome to Myelesson! Here you can learn how to use Vlookup. This tutorial is also available in video format , to see the video version please Click Here For Video . 
 What Does Vlookup do: Vlookup finds a specific value for you based on a given criteria from a data range.
Lets understand the  vlookup formula =vlookup(lookup value,Table array, col_index_num,[range_lookup])

1. Lookup value = This the value based on which we excel would try to find your answer.Now we have to ensure that this lookup value should be present in the data range from where you want to get the result and the result which you are looking for should be on the right hand side of the lookup value,
2. Table array = This is the data range from which you want your result from , we should ensure that the data is sorted . The table array should be sorted also note that if the lookup value exists more than once in the table array then the 1st occurrence would be given as answer by Excel.
3. Col_Index_num = This is the column number from which excel would search for data in the table array. When counting the column number start counting from the  column which contains the lookup value  
4.  Range lookup = When you use a Vlookup formula excel gives you the option to look for either a exact match or a approximate match , 0 means exact match and 1 means approximate match . 

 See the Free Training Video

1. How To Use Vlookup (Hindi)
2. How To Use Vlookup (English)    

For more free videos visit www.myelesson.org