Modify Formula to ignore character

[score]

Please, may someone can help to modify this formula to ignore character * and evaluate the numeric value on the referenced cells. I using this formula to sume the 2 largest values on the range of cells G39:G50 or to return the just one value

=IFERROR(IF(COUNT(G39:G50)=1,SUM(G39:G50),LARGE(G39:G50,1)+LARGE(G39:G50,2)),"0.00")

Some time i need to add an * leading the numeric value on the referenced cells G39:G50 Eg. may one or more of this cells have
the content *9 or *4.5 etc. and the formula i'am using does not evaluate this cells. I'am trying to modify the formula to ignore the * and evaluate the numeric value on those cells.

Any help greatly appreciated, thanks!

[persecuted]

I would try this for your equation. Keep in mind that this is an array formula so when you enter it into a cell, submit it by pressing CTRL+SHIFT+ENTER and it will calculate your value of two largest numbers while ignoring the "*" character.

=IFERROR(IF(COUNT(G39:G50)=1,SUM(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50)),LARGE(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50),1)+LARGE(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50),2)),"0.00")

[score]

Thank you very much persecuted, work perfect, thanks for taking of your time to help with this, stoked!!

I would try this for your equation. Keep in mind that this is an array formula so when you enter it into a cell, submit it by pressing CTRL+SHIFT+ENTER and it will calculate your value of two largest numbers while ignoring the "*" character.

=IFERROR(IF(COUNT(G39:G50)=1,SUM(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50)),LARGE(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50),1)+LARGE(IF(LEFT(G39:G50,1)="*",VALUE(RIGHT(G39:G50,LEN(G39:G50)-1)),G39:G50),2)),"0.00")