Hi,
I am stuck with a simple looking formula to implement in my worksheet...

There are columns A and B for e.g., each having data in some rows, say row 1 to 100.

I want to count the number of rows that have:

A = " X " AND B = " Y "

The above two conditions should be satisfied for a row to be counted

Thanks in advance for the help

Puneet