Need help with formula calculations

[Acez_404]

Hello folks, I've spent hours trying to figure out a formula for this. Basically, I want to count the number of times a row has two specific words, in two different cells. If column A contains the word "WHMRA0" and column B contains the word 'PFC' I want to count the number of times this occurs.

I'm sure this is easy but as I've stated before, I've spent hours trying to figure it out.

 

[liveinhope]

if you are using excel 2007 or later try this COUNTIFS formula =COUNTIFS(A:A,"WHMRA0",B:B,"PFC")

[TABLE="width: 336"]
<TBODY>[TR]
[TD]texta</SPAN>[/TD]
[TD]textb</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WHMRA0</SPAN>[/TD]
[TD]PFC</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD]<--- COUNTIFS</SPAN>[/TD]
[/TR]
[TR]
[TD]OTHER</SPAN>[/TD]
[TD]LTV</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WHMRA0</SPAN>[/TD]
[TD]UPS</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OTHER</SPAN>[/TD]
[TD]UPS</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WHMRA0</SPAN>[/TD]
[TD]PFC</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SOMEONE</SPAN>[/TD]
[TD]LTV</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OTHER</SPAN>[/TD]
[TD]KIL</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SOMEONE</SPAN>[/TD]
[TD]GOO</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OTHER</SPAN>[/TD]
[TD]PFC</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=2><COL></COLGROUP>[/TABLE]