#### dmacdougall

##### New Member

- Joined
- Oct 18, 2005

- Messages
- 43

I also know this is a simple question, but always seem to miss the obvious.

I have two columns of data, Column A and B. I'd like to count the number of rows in which the value in Column A equals one value, and the value in Column B equals another value.

But, I'd like to do this all on one formula, for multiple rows, so as to obtain an aggregrate total, telling me the total number of matches found for each row.

I can't use a array formula (Mr. Excel terms these "CSE Formulas") as the array matches all instances against each other, and I need to query row by row. Here is one formula I came up with, but I need help to be able to use this formula over a range of rows at one time, other than just repeating the same formula over and over again, substituting the next row each time.

How can I do this with this formula, other than in an array?

=Count(And(If(A2="FL",1,0),If(B2="Yes",1,0)))

An array might look like this, but as I said above, simply creating an array does not work, as I don't know how to tell Excel to not count every possible match, but only matches that occur in the same row...

{=Count(And(If(A2:A10="FL",1,0),If(B2:B10="Yes",1,0)))}

Help! Why can I figure out the obvious solution to this problem?!