Adding cells across multiple sheets

Closed
Report
-
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.:-)