View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soph
 
Posts: n/a
Default summing part of a string, excluding cells

Hi!

I have a very similar question to that posted by Arturo. I have a column of
cells to sum where each cell has either a letter and 3 numbers or simply an
"X".
eg: a1 = C6.5
I can use the formula advised