Hi,

Am Fri, 14 Aug 2015 14:24:38 -0700 (PDT) schrieb :

How about if you wanted to count the blank cells in B2:B11 where A2:A11="cond"? Any suggestions on how to do that?

try:

=COUNTIFS(A2:A11,"cond",B2:B11,"")

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional