Return to Answer

If I understand your question, I think a regular expression search might do the trick. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.*)\).*

And replace with: if($1 = 0), "", $1)/7)

I think that should do it.

If I understand your question, I think a regular expression search might do the trick. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.\*)\\).*

And replace with: if($1 = 0), "", $1)/7)

I think that should do it.

Sheets will let you do a "regular expression" replace. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.*)\).*

And replace with: if($1 = 0), '', Countif('2019'!$C2:$Z8, '2')/7)

I think that should do it.

If I understand your question, I think a regular expression search might do the trick. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.*)\).*

And replace with: if($1 = 0), "", $1)/7)

I think that should do it.

Sheets will let you do a "regular expression" replace. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.)).

And replace with: if($1 = 0), '', Countif('2019'!$C2:$Z8, '2')/7)

I think that should do it.

Sheets will let you do a "regular expression" replace. In the replace dialog, check the box for regular expression and search within formulas.

Try searching for: (Count.*)\).*

And replace with: if($1 = 0), '', Countif('2019'!$C2:$Z8, '2')/7)

I think that should do it.