trafixxo

Is there a way we can count or display the sum of bold text in the spreadsheet? Solution: Running a script in Google Apps Script. Cons:      - when the text is changed or updated the sum or count does not update      - need to run the script every time when you edit the spreadsheet function countboldcells () { var book = SpreadsheetApp.getActiveSpreadsheet(); var sheet = book.getActiveSheet(); var range_input = sheet.getRange( "A2:A18" ); var range_output = sheet.getRange( "A19" ); var cell_styles = range_input.getFontWeights(); // getFontStyle can only return 'italic' or 'normal' var count = 0 ; for ( var r = 0 ; r < cell_styles.length; r++) { for ( var c = 0 ; c < cell_styles[ 0 ].length; c++) { // isBold is a method for Google Documents only (not sheets) if (cell_styles[r][c] === "bold" ) { // you need at least two '=' signs // also include the index of cell_styles count = count + 1 ; // count += 1 would al...