Here are some interesting Operating system and softwares tips and tricks 4u.JUST CLICK ON THE PICTURE IN THE BLOG FOR ENALARGED VIEW.


Friday, February 24, 2012

Count a term in a particular cell area(Excel XP, 2003, 2007, 2010)

                You want to determine how many times a term is repeated in a specifi c area of a table, e.g. how many times the name of a city appears in a list.
                You would normally use an array formula to summarize individual functions and conditions for the area. The exact defi nition of the formula depends on whether you want to differentiate between the upper and the lower cases and whether you want exact compliance with the search result.
                The fastest way to get the desired result is using the array formula =COUNTIF(A5:E15,‘Text’). This will fi nd and count all results containing the search term, irrespective of the spelling. For example, if you are searching for the city Mumbai, then type the formula as =COUNTIF(A5:E15,‘Mumbai’).


Post a Comment

please write your comment

Note: Only a member of this blog may post a comment.

THE WINDOWS TRICKS Headline Animator