Sumproduct?
 

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

Sumproduct?
 

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" 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

Sumproduct?
 

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

"Mike H" wrote:

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" 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

Sumproduct?
 

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

Sumproduct?
 

try this
=sum(d4:d10*c4:c10)
arry 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

Sumproduct?
 

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