Forum Discussion
Solved
SUMIF. look for either of two values
I am trying to use SUMIF using to add numbers in a column if the search column finds either of two values. I though that I might be able to us the OR function as the second argument but I can't fin...
Thanks. I did a work around by making an column which calculated the even numbers. Your suggestion is much more elegant.
Nick
You mention column B twice. If you want to sum numbers in column B where column A contains 2 or 3:
=SUMIFS(B1:B100, A1, A100, 2)+SUMIFS(B1:B100, A1:A100, 3)
or shorter:
=SUM(SUMIFS(B1:B100, A1:A100, {2, 3}))
or if there are no text values in column B:
=SUM(B1:B100*((A1:A100=2)+(A1:A100=3)))
Thanks. I did a work around by making an column which calculated the even numbers. Your suggestion is much more elegant.
Nick