I have a formula for SUMPRODUCT -
=SUMPRODUCT((($A$2:$A$4794=A2)*($C$2:$C$4794=C2)*( $D$2:$D$4794=D2))). It
counts the # of distrubutions for me with these 3 critiria and it works. But
now I need to add the value of these columns , (money paid). I have a sample
of what I want using 2 arrays (critiria), but I am having problems applying
this to the formula above. The sample is as follows:

=SUMPRODUCT(($a$2:$a$4794=a2)*($C$2:$C$4794=C2)*$j $2:$j$4794)
I want to adjust this formula to the above formula.

=SUMPRODUCT(($A$2:$A$4794=A2)*($C$2:$C$4794=C2)*($ D$2:$D$4794=D2)*$j$2:$j$4794)
should work.

"klafert" wrote:

I have a formula for SUMPRODUCT -
=SUMPRODUCT((($A$2:$A$4794=A2)*($C$2:$C$4794=C2)*( $D$2:$D$4794=D2))). It
counts the # of distrubutions for me with these 3 critiria and it works. But
now I need to add the value of these columns , (money paid). I have a sample
of what I want using 2 arrays (critiria), but I am having problems applying
this to the formula above. The sample is as follows:

=SUMPRODUCT(($a$2:$a$4794=a2)*($C$2:$C$4794=C2)*$j $2:$j$4794)
I want to adjust this formula to the above formula.

Thanks, I came up with this formula ,
=SUMPRODUCT((($A$2:$A$4794=A8)*($C$2:$C$4794=C8)*( $J$2:$J$4794))), while
waiting for a response. Your forumula works also and is less confusing.

"bj" wrote:

=SUMPRODUCT(($A$2:$A$4794=A2)*($C$2:$C$4794=C2)*($ D$2:$D$4794=D2)*$j$2:$j$4794)
should work.

"klafert" wrote:

I have a formula for SUMPRODUCT -
=SUMPRODUCT((($A$2:$A$4794=A2)*($C$2:$C$4794=C2)*( $D$2:$D$4794=D2))). It
counts the # of distrubutions for me with these 3 critiria and it works. But
now I need to add the value of these columns , (money paid). I have a sample
of what I want using 2 arrays (critiria), but I am having problems applying
this to the formula above. The sample is as follows:

=SUMPRODUCT(($a$2:$a$4794=a2)*($C$2:$C$4794=C2)*$j $2:$j$4794)
I want to adjust this formula to the above formula.