Thanks, but the "NOT" is throwing me.

"Herbert Seidenberg" wrote:

If you enter a 2D array (A2:C6) into SUMIF(), it will use
only the first column of that array, A2:A6.
If you want the formula to say: "Look in either column A or B"
then you have to use an OR function.
SUMIF does not accept an OR function.
SUMPRODUCT is formulated as an AND function,
but you can convert it to an OR function by using DeMorgan's theorem.
=SUMPRODUCT(NOT(NOT(A2:A6=A13)*NOT(B2:B6=A13))*C2: C6) or
=SUMPRODUCT(NOT((A2:A6<A13)*(B2:B6<A13))*C2:C6)