SumProduct meeting two criteria
 

Hello!

I am trying to figure out to count the sum of product that meets two
criteria. Here is what I am currently using and my value is zero, and I know
that is not true.

=SUMPRODUCT(--(G4:G449="150000"),--(M4:M449="100%"))


PLEASE HELP!!!!!!!!!!!!!!!!!!!!

SumProduct meeting two criteria
 

=SUMPRODUCT(--(G4:G449=150000),--(M4:M449=1))

"Mindy" wrote:

Hello!

I am trying to figure out to count the sum of product that meets two
criteria. Here is what I am currently using and my value is zero, and I know
that is not true.

=SUMPRODUCT(--(G4:G449="150000"),--(M4:M449="100%"))


PLEASE HELP!!!!!!!!!!!!!!!!!!!!

SumProduct meeting two criteria
 

Hi, I made the reflected changes and I am still getting the same thing 0. Any
other suggestions would greatly appreciated!


"Teethless mama" wrote:

=SUMPRODUCT(--(G4:G449=150000),--(M4:M449=1))

"Mindy" wrote:

Hello!

I am trying to figure out to count the sum of product that meets two
criteria. Here is what I am currently using and my value is zero, and I know
that is not true.

=SUMPRODUCT(--(G4:G449="150000"),--(M4:M449="100%"))


PLEASE HELP!!!!!!!!!!!!!!!!!!!!

SumProduct meeting two criteria
 

My bet is that the numbers you are checking for aren't *exactly* 150,000 and
100%. They're close, but not exact. To accommodate "close enough", try:
=SUMPRODUCT(--(ROUND(G4:G449,2)=150000),--(ROUND(M4:M449,2)=1))

Regards,
Fred


"Mindy" wrote in message
...
Hi, I made the reflected changes and I am still getting the same thing 0.
Any
other suggestions would greatly appreciated!


"Teethless mama" wrote:

=SUMPRODUCT(--(G4:G449=150000),--(M4:M449=1))

"Mindy" wrote:

Hello!

I am trying to figure out to count the sum of product that meets two
criteria. Here is what I am currently using and my value is zero, and
I know
that is not true.

=SUMPRODUCT(--(G4:G449="150000"),--(M4:M449="100%"))


PLEASE HELP!!!!!!!!!!!!!!!!!!!!

SumProduct meeting two criteria
 

Thanks, Fred! Your bet was right. Thanks, now I won't have to pull my hair
out! ;)


"Fred Smith" wrote:

My bet is that the numbers you are checking for aren't *exactly* 150,000 and
100%. They're close, but not exact. To accommodate "close enough", try:
=SUMPRODUCT(--(ROUND(G4:G449,2)=150000),--(ROUND(M4:M449,2)=1))

Regards,
Fred


"Mindy" wrote in message
...
Hi, I made the reflected changes and I am still getting the same thing 0.
Any
other suggestions would greatly appreciated!


"Teethless mama" wrote:

=SUMPRODUCT(--(G4:G449=150000),--(M4:M449=1))

"Mindy" wrote:

Hello!

I am trying to figure out to count the sum of product that meets two
criteria. Here is what I am currently using and my value is zero, and
I know
that is not true.

=SUMPRODUCT(--(G4:G449="150000"),--(M4:M449="100%"))


PLEASE HELP!!!!!!!!!!!!!!!!!!!!