There is an excellent page here which shows several ways to do this:http://www.ozgrid.com/Excel/count-if.htm