sumproduct question

[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

 

[RagDyer]

If I understand what you're asking,

=SUMPRODUCT((A1:A20="Criteria1")*(B1:B20="Criteria2")*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