text to be assigned as number

[Aboiy Davantes]

Please try to help me resolve this complicated
calculation, for i have a little knowledge when it comes
to excel calculation.

1
1
1 of 3 ( must be assigned as "1" )
4
5
2 of 3 ( = 1 )
3 of 3 ( = 1 )
5

if ill use to add it using SUM, it will give a result of
16, i need to assigned every text as equivalent to "1" so
it will give me a result of "19" instead of "16"

Thank you in advance

 

[Paul Corrado]

Aboiy,

The following Array Formula will work for you. (Use CTRL+SHIFT+ENTER when
entering the formula)

=SUM(IF(ISTEXT(A1:A8)=TRUE,1,A1:A8))

PC

 

[Ron Rosenfeld]

Please try to help me resolve this complicated
calculation, for i have a little knowledge when it comes
to excel calculation.

1
1
1 of 3 ( must be assigned as "1" )
4
5
2 of 3 ( = 1 )
3 of 3 ( = 1 )
5

if ill use to add it using SUM, it will give a result of
16, i need to assigned every text as equivalent to "1" so
it will give me a result of "19" instead of "16"

Thank you in advance

=SUM(A1:A8)-COUNT(A1:A8)+COUNTA(A1:A8)


--ron