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")

No comments:

Post a Comment