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.
No comments:
Post a Comment