How do I get the alphabet be taken as 0 in formula

N

nanz

I want to display the alphabet in the table and want it to be taken as 0
during computation. How should I get this thing done?
 
D

Dave Peterson

Lots of worksheet functions will ignore alphanumeric entries.

=sum(a1:a10)

will ignore any text you have in A1:A10.

But you could be explicit when you need to be:

=n(a1)+n(a2)
 
Top