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

If I understand what you're asking,

=SUMPRODUCT((A1:A20="Criteria1")*(B1:B20="Criteria 2")*C1:C20)*3

Where "3" is your #.

It's best to assign your criteria to specific cells, along with your
multiplier, such as:

=SUMPRODUCT((A1:A20=D1)*(B1:B20=D2)*C1:C20)*D3

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jxbeeman" wrote in message
...
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