Thanks Claus Busch!
Sorry for the extremely late reply and thank you. I really thought I had replied in the past.
Quote:
Originally Posted by Claus Busch
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
|