convert text & multiply

[Guest]

Is it possible to create a function/formula which will count certain text in
a row and then convert them to a value and allow it to be multiplied by a
value?

 

[Peo Sjoblom]

Are these text values in one cell or are they spread out like

A1 B1 C1 D1 E1 F1 G1
E DO L OD E L DO

if so you could use

=SUMPRODUCT(--(A1:G1={"E";"L";"OD"}))*7.5

 

[CLR]

=(COUNTIF(A1:G1,"E")+COUNTIF(A1:G1,"L")+COUNTIF(A1:G1,"OD"))*7.5

Vaya con Dios,
Chuck, CABGx3

Is it possible to create a function/formula which will count certain text in
a row and then convert them to a value and allow it to be multiplied by a
value?

of these being 7.5 then multiplied by the amount of times they appear e.g.
5x7.5 = 37.5.