Sumif between a range

[Guest]

Help please with the following:

=SUMIF('<100'!$K:$K,">2" or "<=12",'<100'!$E:$E) or
something like between "2" and "12".


Cheers,
John

 

[Don Guillett]

=sumproduct((rngA>2)*(rngA<=12)*rngB)

 

[Dave Peterson]

=sumif('<100'!$k:$k,">=2") - sumif('<100'!$k:$k,">12")

Will include 2's and 12's in the sum.

I'm not sure what should happen at those values (2 and 12).

 

[Dave Peterson]

I misread the question.

=SUMIF($K:$K,">=2",E:E) - SUMIF($K:$K,">12",E:E)