Count in a range how many meet two conditions across a row, VBA

[Technowolf]

Okay, I don't think this is that hard but I'm not sure exactly how to do it.
I want it to count how many times something meets two conditions across a row. For example, I want to know how many times A is 1F and B is 20, but only if they're on the same row together (as in, don't count 1D & 20 or 1F & 10, etc). I want it to check how many times that happens for the whole set of data. And show the results in cell C1.

A	B	C
1F	20
1D	20
1F	10
1D	20
1F	20
1F	10
1D	20
1D	10
1D	20
1F	20

<tbody>
</tbody>

Suggestions?

 

[Marcelo Branco]

Try (Excel 2007 or higher)

=COUNTIFS(A:A,"1F",B:B,20)

M.

 

[Technowolf]

Okay, yeah that I started with a countifs but didn't know if it would pair rows. I can work with that. Okay, followup question.
(because I need to use this in a macro)
How do I make a formula work with quotes in a macro?

Range("C2").Formula = "[COLOR=#333333]COUNTIFS(A:A,"1F",B:B,20)[/COLOR]"

But the "s around the "1F" screw up the macro. How do I make that work?

 

[Technowolf]

Ahhh I figured it out. Have to double "".

[COLOR=#333333]Range("C2").Formula = "[/COLOR][COLOR=#333333][COLOR=#333333]COUNTIFS(A:A,""1F"",B:B,20)[/COLOR][/COLOR][COLOR=#333333]"[/COLOR]