Trying to use the OR logical operator in SUMIF, for example
SUMIF(OR($H=”I0000″,$H=”I0001)”),$J)
—–
Tim Swaty
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Use SUMIF With Logical Operators?
Comments: 2 Responses to “How Do I Use SUMIF With Logical Operators?”
Comments Closed.
That OR function doesn't work because the comparisons inside it are trying to compare an entire column to a single value. Is row H equal to "I0000"? No, because H is a row, not a cell and it can't be equal to a single value.
One way to do what you want is to create another column. So make K2 the formula OR(H2="I0000",H2="I0001") and paste that throughout K to get TRUE and FALSE values in K. Then you can use SUMIF(K,true,J) as your formula. Then hide column K if you like.
Thanks Gary. That makes sense to me.