| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with multiple criteria
I have a very simple sumif with mulitple criteria, but I can't get the
correct result. This is my formula. Shouldn't the "*" indicate the "and" operator? =SUMIF($B$8:$B$135,($B$8:$B$135=GO143)*($J$8:$J$13 5=$GR$142),$ER$8:$ER$135) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif with multiple criteria | Excel Discussion (Misc queries) | |||
| SUMIF - multiple criteria in different columns | Excel Worksheet Functions | |||
| SUMIF multiple criteria | Excel Discussion (Misc queries) | |||
| SUMIF with multiple criteria | Excel Worksheet Functions | |||
| SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
