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")

texta</SPAN>	textb</SPAN>
WHMRA0</SPAN>	PFC</SPAN>	2</SPAN>	<--- COUNTIFS</SPAN>
OTHER</SPAN>	LTV</SPAN>
WHMRA0</SPAN>	UPS</SPAN>
OTHER</SPAN>	UPS</SPAN>
WHMRA0</SPAN>	PFC</SPAN>
SOMEONE</SPAN>	LTV</SPAN>
OTHER</SPAN>	KIL</SPAN>
SOMEONE</SPAN>	GOO</SPAN>
OTHER</SPAN>	PFC</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=2><COL></COLGROUP>