SumProduct meeting two criteria

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

Mindy

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top