Sumif between a range
 

Help please with the following:

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


Cheers,
John

Sumif between a range
 

=sumproduct((rngA2)*(rngA<=12)*rngB)

--
Don Guillett
SalesAid Software

"John" wrote in message
...
Help please with the following:

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


Cheers,
John

Sumif between a range
 

=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).



John wrote:

Help please with the following:

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

Cheers,
John

--

Dave Peterson

Sumif between a range
 

I misread the question.

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


Dave Peterson wrote:

=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).

John wrote:

Help please with the following:

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

Cheers,
John

--

Dave Peterson

--

Dave Peterson