Google script for counting words in cell ranges.

CountWords.gs

function onOpen() {
  var menu = [{name: 'Count Words', functionName: 'countWords'}];
  SpreadsheetApp.getActive().addMenu('Count', menu);
}

function countWords() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getActiveRange().getValues();
  
  var s = "";
  for (var i in data) {
    for (var j in data[i]) {
      var v = data[i][j];
      s += v + " ";
    }
  }
  
  s = s.trim();
  
  var sa = s.split(" ");
  var sCount = sa.length;
  
  Logger.log(sa);
  Logger.log(sCount);
  
  sheet.appendRow(['Word Count', sCount]);
}