Thread: countif functions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default countif functions
Try
=SUMPRODUCT((A1:A10=10)*(A1:A6<=20))

For info on sumproduct see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

- John
www.JohnMichl.com

Reply With QuoteReply With Quote