I think I understood your problem. If this is Excel 2007, Countifs function should do the needful. For earlier versions of Excel, create one column which is concatenation of New Business column and the area colum and run a countif for a string "yes" and area name. e.g. ikf the area name is "A" run a countif for "yes"&"A"