Adding cells across multiple sheets

Closed
dalet - Apr 12, 2015 at 06:01 PM
Hello,
Trying to add same cell across different sheets..after a bunch of tries with formulas..finally got it but it wont add cuz it has a text..how can i add the cells.
=SUM (512MC:UNION!A3)
A3 =140 FT.
All A3 have the FT. After the numbers.Thanks in advance.:-)