text to be assigned as number

  • Thread starter Thread starter Aboiy Davantes
  • Start date Start date
A

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
 
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
 
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
Click to expand...


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


--ron
 
Back
Top