SumProduct meeting two criteria

  • Thread starter Thread starter Mindy
  • Start date Start date
M

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!!!!!!!!!!!!!!!!!!!!
 
Hi, I made the reflected changes and I am still getting the same thing 0. Any
other suggestions would greatly appreciated!
 
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
 
Back
Top