View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mindy Mindy is offline
external usenet poster
 
Posts: 25
Default 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!!!!!!!!!!!!!!!!!!!!