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.