How to count the number of cells in a google spreadsheet?

Question

Google Sheets

Good afternoon, there is a table in which there are just a lot of sheets + a lot of values ​​​​on each of the sheets. I would like to know how to count the number of filled cells in all sheets. In Google help, the closest COUNT command, but there you need to specify the range on one sheet, this is not fast at all, maybe there is something better?

Answer 1

Solved by installing the size my sheet add-on.

Answer 2

function getSSsize(){
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  var total = 0;
  for (var i=0 ; i<sheets.length ; i++){
    var dataValues = sheets[i].getDataRange().getValues();
    var item = dataValues[0].length*dataValues.length;
    Logger.log('%s: %s', sheets[i].getName(), item);
    total += item; 
  }
  Logger.log('Total:  %s', total);
}