SumProduct meeting two criteria

[Mindy]

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

 

[Teethless mama]

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

 

[Mindy]

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

 

[Fred Smith]

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]

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