ExcelBanter - HOW CAN I ADDS UP INCHES NUMBERS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW CAN I ADDS UP INCHES NUMBERS? (https://www.excelbanter.com/excel-discussion-misc-queries/36294-how-can-i-adds-up-inches-numbers.html)

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

Bill Martin -- (Remove NOSPAM from address)

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

N Harkawat

=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

All times are GMT +1. The time now is 04:33 PM.