Issue ... I wish to exclude "text" that looks like
numbers in Range D4:D50.

Try this:

=SUMPRODUCT(C4:C50,D4:D50)

--
Biff
Microsoft Excel MVP


"ADIB" wrote in message
...
try this
=sum(d4:d10*c4:c10)
array so enter with control+shift+enter

"Ken" wrote:

Excel2003 ... My Formula:

=SUMPRODUCT(--($C$4:$C$50)*--(D4:D50))

Issue ... I wish to exclude "text" that looks like numbers in Range
D4:D50.

Thanks ... Kha