| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUM if with 3 criteria
For some reason the --(Input!$K$2:$K$1000=$J$18), Criteria doesn't work? I've used the following formula: =SUMPRODUCT(--(Input!$G$2:$G$1000=$J$19),--(Input!$K$2:$K$1000=$J$18),--(Input!$A$2:$A$1000=A21)*Input!$E$2:$E$1000) Could it be that the cells in Input!K2:K1000 column have formulas in them? Help Please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max value that meets a criteria | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
