=SUMPRODUCT(--(SUBSTITUTE(D16:D19,"-","")))
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"mikeburg" wrote in
message ...
Need formula in cell D20 to sum total numbers with dashes in them. For
example:
In cells D7 thru D16
D16 | 450-33-6320
D17 | 83-0381086
D18 | 459-15-6027
D19 | 75-2708781
In cell D20 | 2,492,582,214 Control total
Thanks a million, mikeburg
--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=505522