SUMIF. look for either of two values

Question

I am trying to use SUMIF using to add numbers in a column if the search column finds either of two&nbsp; values.&nbsp; I though that I might be able to us the OR function as the second argument but I can't find how to do this.The data that I have looks something like this:A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 121&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 181&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 431&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 252&nbsp;&nbsp; &nbsp; &nbsp; 823&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; 173&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8I want to add all the numbers in B which have either 2 or 3 in the corresponding rows in column B.Bothered if I can work our how.&nbsp;Nick

nicholas cooke · Accepted Answer

Thanks.&nbsp; I did a work around by making an column which calculated the even numbers.&nbsp; Your suggestion is much more elegant.&nbsp;Nick

Forum Discussion

SUMIF. look for either of two values

Resources