Sumproduct?

Ken · Mar 26, 2008

Excel2003 ... My Formula:

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

50))

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

50.

Thanks ... Kha

Mike H · Mar 26, 2008

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 · Mar 26, 2008

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

ADIB · Feb 13, 2009

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

ADIB · Feb 13, 2009

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

T. Valko · Feb 13, 2009

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

numbers in Range D450.

Try this:

=SUMPRODUCT(C4:C50,D4

50)