View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tina tina is offline
external usenet poster
 
Posts: 139
Default 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)