Thread
:
countif functions
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
John Michl
Posts: n/a
countif functions
Try
=SUMPRODUCT((A1:A10=10)*(A1:A10<=20))
For info on sumproduct see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
- John
www.JohnMichl.com
Reply With Quote