When using SUMIF, is the [sum_range] restricted to values in a single column?
To explain my question I have the following data:

ADD LIST A LIST B
Y 120 0
85 217
Y 0 50
Y 40 92

When I insert the formula "=SUMIF($A$2:$A$5,"Y",$B$2:$C$5)" I am getting the
value 160 because the sum_range of $B$2:$C$5 is returning only the sum of
values in column B. What I would like is to see a value of 302.

Is it possible for the [sum_range] to be a range across multiple contiguous
columns?

Thanks in advance