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