Sumproduct?

[Ken]

Excel2003 ... My Formula:

=SUMPRODUCT(--($C$4:$C$50)*--(D450))

Issue ... I wish to exclude "text" that looks like numbers in Range D450.

Thanks ... Kha

 

[Mike H]

Maybe

=SUM(IF(ISNUMBER($D$4:$D$10),$D$4:$D$10*$C$4:$C$10,0))

Array so enter with Ctrl+Shift+Enter

Mike

 

[Ken]

A little adjustment for my Range & Perfect ... Thanks ... Kha

 

[ADIB]

try this
=sum(d4:d10*c4:c10)
array so enter with control+shift+enter

 

[ADIB]

try this
=sum(d4:d10*c4:c10)
arry so enter with control+shift+enter

 

[T. Valko]

Issue ... I wish to exclude "text" that looks like

numbers in Range D450.

Try this:

=SUMPRODUCT(C4:C50,D450)