Try:

=SUMPRODUCT(($B$8:$B$135=GO143)*($J$8:$J$135=$GR$1 42),$ER$8:$ER$135)



On Feb 2, 9:27 am, Tina wrote:
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)