Count COL B where COL B = X AND COL A = Y

[MitMcC]

I'm trying to do an excel formula in which I count the number of rows filtered on specified values of two columns.

For example I have spreadsheet with 10 rows and 3 columns and I want to count the number of rows in which Column 1 has a value of Y and Column 3 has a value of X. For example:

1 2 3
X 1 A
X 1 A
X 1 A
X 1 A
X 1 A
X 1 Y
B 1 Y
B 1 Y
B 1 Y
B 1 Y

The answer to my formula = 1 row since only row 6 has both X in column 1 and Y in column 3.

thanks!

[duane]

=sumproduct(--(a1:a100="x"),--(c1:c100="y"))
or
=sumproduct((a1:a100="x")*(c1:c100="y"))