I am trying to sum numbers with dashes across multiple sheets to sum quarterback passing totals. I am looking for a formula for sheet3 cell B1 to sum the numbers from sheet1 B1 and sheet2 B1.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Example:<o></o>
<o></o>
Sheet1<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
6-9-0<o></o>
<o></o>
Sheet2<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
5-10-1<o></o>
<o></o>
Sheet3<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
11-19-1 (need formula for this cell)<o></o>
<o></o>
<o>Thanks,<o></o>
Kurt<o></o>
</o>
<o></o>
Example:<o></o>
<o></o>
Sheet1<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
6-9-0<o></o>
<o></o>
Sheet2<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
5-10-1<o></o>
<o></o>
Sheet3<o></o>
Cell A1:<o></o>
Completions-Attempts-Int<o></o>
Cell B1:<o></o>
11-19-1 (need formula for this cell)<o></o>
<o></o>
<o>Thanks,<o></o>
Kurt<o></o>
</o>