Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following formula for adding numbers that match two criteria that works fine
=SUMPRODUCT(--($E$125:$E$1084=AM4),--($AS$125:$AS$1084="yes"),$K$125:$K$1084) I want to add a third criteria so I did this: =SUMPRODUCT(--($E$125:$E$1084=AM4),--($E$125:$E$1084=AM34),--($AS$125:$AS$1084="yes"),$K$125:$K$1084) and now the formula result is always 0 How can I add a third criteria to be checked before adding the matches in column K? Thanks MB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multple criteria dilemma | Excel Worksheet Functions | |||
DCOUNTA Complex Criteria Question | Excel Worksheet Functions | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |