Thread: sum numbers which contain characters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelFan excelFan is offline
external usenet poster
  
Posts: 53
Default sum numbers which contain characters
in column A (A1:A11)
12
c8
22
c1
54
c19
c6
25
c3
c7
55
how to get the sum only for those number which begins with "c"?
many thanks for any help

Reply With QuoteReply With Quote