Thread: Sumif between a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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

Reply With QuoteReply With Quote