const calledFromSS = SpreadsheetApp.getActive();
  const newSS = calledFromSS.duplicateActiveSheet();
  const range = newSS.getRange('E3:F8');
  const protection = range.protect();//.setDescription('Test');
  // Удаление всех из редактирования диапазона, кроме себя.
  const owner = Session.getEffectiveUser();
  protection.addEditor(owner);
  protection.removeEditors(protection.getEditors());
  if (protection.canDomainEdit()) {
    protection.setDomainEdit(false);
  }

const range = newSS.getRange('E3:F8');

(?<=\\/\\/)[^\\.]+

//[^\.]+(?=\.)

[^/]+

//[^\.]+\.

\/\/[^\.]+\.

\/\/[^\.]+(?=\.)

(?<=\/\/)[^\.]+(?=\.)

(?<=\.)[^\.]+(?=\.io)

(?<=\.io\/)[^\/]+

(?<=,\s)(?!\s?г|\s?р-н|\s?кв|\s?д)[^,]+(?=,)

=ЕСЛИОШИБКА(ПОДСТАВИТЬ($A1;RegExp($A1;"(\d+[xXхХ]){1,2}\d+");"");$A1)

=ЕСЛИОШИБКА(ПОДСТАВИТЬ($A2;RegExp($A2;"\d+[хХxX]\d+");"");$A2)

https://www.planetaexcel.ru/forum/index.php?PAGE_NAME=read&FID=1&TID=157981&TITLE_SEO=157981-izvlechenie-html-tablits

?PAGE_NAME=read&FID=1&TID=157981&TITLE_SEO=157981-izvlechenie-html-tablits

function SummOrCountIfMatch(cell, mode, addNum = 0) {
 addNum *= 1;
 const haveDoll = cell.search(/\$/g);
 const priceArr = haveDoll < 0 ? cell.match(/(\-)?\d+(\.\d{1,2})?/g) : cell.match(/(?<=\$)(\-)?\d+(\.\d{1,2})?/g);
 const countElems = haveDoll < 0 ? cell.split(/\d+/g).length - 1 : cell.split('$').length - 1;
 if (mode) {
    return countElems;
  } else {
    return priceArr.reduce((acc, number) => Number(acc) + (Number(number) + addNum))*1 + addNum;
  }
};

=SummOrCountIfMatch(cell;mode;addNum)

=SummOrCountIfMatch(cell)

function CountAllIfMatchDollar(cell) {
 const priceArr = cell.match(/(?<=\$)(\-)?\d+(\.\d{1,2})?/g);
 return priceArr.reduce((acc, number) => Number(acc) + Number(number))*1;
}

=CountAllIfMatchDollar(A1)

function CountAllIfMatchDollar(cell) {
 const addNum = Number(35);
 const priceArr = cell.match(/(?<=\$)(\-)?\d+(\.\d{1,2})?/g);
 return priceArr.reduce((acc, number) => Number(acc) + (Number(number) + addNum))*1 + addNum;
}