hi Yasser,

Am Fri, 1 May 2015 17:55:41 +0100 schrieb ymadi:

I’m trying to count the number of nonblank rows in column B where rows
in Column A = 1.1
A B C
1.1 X Formula Returns 3
1.1
1.1 X
1.1 X
2.1 X
2.1
2.1 X

for Excel Version 2007 or later:
=COUNTIFS(A:A,1.1,B:B,"<"&"")
else
=SUMPRODUCT(--(A1:A100=1.1),--(B1:B100<""))


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