J
jxbeeman
Hi,
What I'm trying to do is to use a constant value in the sumproduct equation.
Example
column 1 column 2 column 3 (#)
so if i took sumproduct(--(col 1.....),--(col 2....), (#) * (col 3....))
so basically i want to multiply # by all the elemets in the array (col 3) if
case 1 and 2 are true. Can this be done this way? I know i can turn the #
into a column of numbers and use it as an array that way, but i'm wondering
if there is someway to transform the value to an array in the formula. Ex. 1
* (1X12 array) ==> 1X12
Thanks for the help, josh
What I'm trying to do is to use a constant value in the sumproduct equation.
Example
column 1 column 2 column 3 (#)
so if i took sumproduct(--(col 1.....),--(col 2....), (#) * (col 3....))
so basically i want to multiply # by all the elemets in the array (col 3) if
case 1 and 2 are true. Can this be done this way? I know i can turn the #
into a column of numbers and use it as an array that way, but i'm wondering
if there is someway to transform the value to an array in the formula. Ex. 1
* (1X12 array) ==> 1X12
Thanks for the help, josh