Formula/array to count # of times col. A is Greater than col. B if they're in County "X...

Here is the deal. I have a spreadsheet with columns A-N.

Column E is the County.
Column L is the Rep.
Column P is Estimated $.
Column Q is Actual $.

I need a formula that will count how many times column P is greater than column Q if column E is "X" and column L is "Y".

Thanks for the help guys.

Stan

Try

=SUMPRODUCT(--(P2:P100>Q2:Q100),--(E2:E100="x"),--(L2:L100="Y"))

Brother! Ya nailed it!

Thanks for the help.

You're welcome.