Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum "Fomula Values"
=--(A1&B1&C1)
-- David Biddulph "Abdul Shakeel" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum "Fomula Values"
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. "David Biddulph" wrote: =--(A1&B1&C1) -- David Biddulph "Abdul Shakeel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
fomula needed to find the "new" time, for example if | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |