Formula Questions
 

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

Formula Questions
 

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeremy" wrote:
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

Formula Questions
 

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

--

"Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message
...
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