View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abdul Shakeel Abdul Shakeel is offline
external usenet poster
 
Posts: 39
Default Sum "Fomula Values"

Hi All,

I used concatenate formula to merge values say I concatenate cells A=1 B=2
C=3 Row no. 1 resultant cell is D=123 same with row no. 2 resultant cell is
D2 how could I sum both resultant cell however I converted both the cells in
number formate.