sumif and multiple columns

U

umass

I am trying to get sumif to sum over multiple columns -- that is, the
criteria are in range A1:A3, and the sum range is over B1:D3, but I
can't get it to work. Is this possible to do?
 
J

JE McGimpsey

One way:

Assume your criterion was A1:A3 > 5:

=SUMPRODUCT((A1:A3>5)*(B1:D3))
 
Top