How to count based on more than one condition ?

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

Use the following formula

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"))

Cheers!