Formula Questions

[Jeremy]

I have the below formula which correctly countd the number of complaints
received for a certain reason. The second part of this formula also allows
for the Monthly Summary$C$1 variable to be changed to bring in a new set of
data.

=SUMPRODUCT(--(Data!$K$7:$K$9998='Monthly
Summary'!$A10),--(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1))

What I am looking to do is use these instances, which is just really a
count, but to add up the corresponding dollar amount for each complaint. The
dollat amount is in Data!$Q$7:$Q$9998

Thanks
Jeremy

 

[Max]

Untested, but think you could try:
=SUMPRODUCT((Data!$K$7:$K$9998='Monthly
Summary'!$A10)*(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1)*Data!$Q$7:$Q$9998)

 

[PCLIVE]

Maybe this:
=SUMPRODUCT(--(Data!$K$7:$K$9998='Monthly
Summary'!$A10),--(Data!$AE$7:$AE$9998='Monthly
Summary'!$C$1),Data!$Q$7:$Q$9998)

HTH,
Paul