Saturday, January 28, 2012

Count functions.... contd....


Continuing where I had left last week on the count functions... let me introduce to you one more count function

Lets have a look at the CountIf function. CountIf alows you to count based on a given criteria. For example you want to count the number of employees with sale above $1000 in the below data


The formula which you can apply will be
=COUNTIF($C$2:$C$9,">1000")

In this formula ">1000", is the criteria, which comprises or the operator greater than. All the relational operators like >, <, <=, >= & <> can be used. These is no need to write equal to, if you want the exact match of 1000 (use "1000" in that case).

Saturday, January 21, 2012

Various Count Functions


And yet again... its been a while since I wrote something last time..... Can't seem to figure out where my time goes... This time no promise of being a regular on this blog... Though will try harder to update it regularly....

Tip that I have for today is the difference between various Count functions.

We all know count function is used to count the number of entries but very few know that the Count function only counts the numeric entries and skips the text and the blanks.

To count the text entries along with the numeric entries, in other words to count all the non blank cells, the function is CountA and to count the blank cells the function is CountBlank.

Here is a screenshot detailing the difference.... enjoy the Excel 2010 look as well.