Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct?? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
Help with SUMPRODUCT | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions |