Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT with 3 criteria
I have 3 columns with the following data in:
RAG status e.g. red, amber, green Types e.g. 1, 2, 3, 4 Project e.g. A1-AA1, A2-BC3, B1-HH1, B2-JK2, B3-JJ2 I want to be able to calculate all type 1s that are Green beginning with A or B etc. I have tried using the following formula: =SUMPRODUCT(--($A$9:$A$85="Green"),--(LEFT($C$9:$C$85)="1"),--(LEFT($D$9:$D$85,7)="A*")) Frustratingly, if I put the full name of the project in, the formula works, but when I use wildcards it doesn't. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT with 3 criteria
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
SumProduct with criteria list | Excel Worksheet Functions | |||
Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |