Hello,
First time excelbanter user. Good to be here.
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

Thanks for your help
Yasser Madi