| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!!!!!!!!!!!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!!!!!!!!!!!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!!!!!!!!!!!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!!!!!!!!!!!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!!!!!!!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count occurences meeting criteria | Excel Worksheet Functions | |||
| using sumproduct on subtotals meeting certain conditions | Excel Worksheet Functions | |||
| calculation based on meeting two criteria | Excel Discussion (Misc queries) | |||
| how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
| COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
Linear Mode
