Showing posts with label countif. Show all posts
Showing posts with label countif. Show all posts

Sunday, 27 September 2009

Count number of occurences of word in Excel range

The example below counts the number of times the word "Computing" appears in Column B of an Excel spreadsheet.
=COUNTIF(B3:B32,"Computing")