If your dates are text strings which say "11-18-05" for example, then the
solution below should work. If they're serial numbers formatted as you show
then, then the problem is trickier....

The following array formula work do the trick. You need to hold down the
control and shift keys while hitting Enter, in order to have excel recognize
it as an array.
{=SUM(IF(ISNUMBER(D3:D43),D3:D43))}

Don't know how well you know array formula.... don't actually type the {}
signs, those get inserted when you enter the formula holding down shift and
control.

"mikeburg" wrote:


Column D3 thru D43 contain a mixture of values & dates. For example:

D3 = 16,026.76
D4 = 11-18-05
D5 = blank
D6 = 6,855.34
D7= 11-03-05
D8 = blank
D9 = 5,270.00
D10 = 11-02-05

Need sum to equal 28,152.10 (total only values from entry or formulas)

Thanks so much. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=489114