Sum "Fomula Values"

  • Thread starter Thread starter Abdul Shakeel
  • Start date Start date
A

Abdul Shakeel

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.
 
Sounds like you have, say,

A B C D

1 1 2 3 =(A1&B1&C1) 123
2 2 6 3 =(A2&B2&C2) 263

Then do =D1+D2 to get 386 as your answer.
 
Back
Top