| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW CAN I ADDS UP INCHES NUMBERS?
how can i adds up inches number in xcell or word? please help me abt this
asap. thanx -- hp |
|
#2
|
|||
|
|||
|
hp wrote:
how can i adds up inches number in xcell or word? please help me abt this asap. thanx On the face of it, if A1 = 6" and A2 = 3" then: [A3] = A1 + A2 would produce A3 = 9". I presume your question is somehow more involved than this? Can you explain it a bit better? Bill |
|
#3
|
|||
|
|||
|
=SUMPRODUCT(--SUBSTITUTE(A1:A200,"""",""))
"hp" wrote in message ... how can i adds up inches number in xcell or word? please help me abt this asap. thanx -- hp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| format numbers into feet / inches | Excel Worksheet Functions | |||
Linear Mode
