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 also work
}
}
}
range_output.setValue(count); // make sure you setValue only when booth loops are done.
} |
Change the code (text in green) to the range of the text.
var range_input = sheet.getRange("A2:A18"); |
Change the code (text in green ) to the cell where the sum will be displayed.
var range_output = sheet.getRange("A19"); |
No comments: