J
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
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