Thread: sum text & numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grizzly6969 grizzly6969 is offline
external usenet poster
  
Posts: 79
Default sum text & numbers
I have a spredsheet
A27 = V8
B27 = V12
C27 = V6
etc. etc.
I would like X27 to equal sum of numbers only , Letter is always "V"
so in this case X27 = 26


--
grizz
Reply With QuoteReply With Quote