compare cell A to corresponding cell B and count if B > A but ignore cells with "<" sign

[dupont]

I have the data set below and I need help to compare cell A to corresponding cell B and count if B > A but ignore cells with "<" sign:
[TABLE="width: 239"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1.2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]213[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]< 1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]< 1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]213[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0.0014[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0.0109[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]0.001[/TD]
[TD]0.00045[/TD]
[/TR]
[TR]
[TD]0.003[/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD]0.003[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]0.005[/TD]
[TD]0.074[/TD]
[/TR]
[TR]
[TD]0.003[/TD]
[TD]0.08[/TD]
[/TR]
[TR]
[TD]0.003[/TD]
[TD]< 0.000020[/TD]
[/TR]
[TR]
[TD]0.015[/TD]
[TD]< 0.000020[/TD]
[/TR]
[TR]
[TD]0.0001[/TD]
[TD]< 2.0[/TD]
[/TR]
[TR]
[TD]0.0001[/TD]
[TD]< 0.000050[/TD]
[/TR]
[TR]
[TD]0.0005[/TD]
[TD]< 0.000050[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]


Thanks

 

[Joe4]

Welcome to the Board!

Assuming your data is in the range A2:B19, try this formula:

=SUMPRODUCT(--(B2:B19>A2:A19),--(LEFT(B2:B19,1)<>"<"))

 

[dupont]

Joe4,

That works, thank you. what does that second part of the formula do?- pardon my limited knowledge in this.

 

[Joe4]

Basically, there are two parts to the formula, and both have to be TRUE in order for the record to be counted.
The first part checks for column B greater than column A.
The second part check for column B NOT to start with a "<" sign (note that "<>" means "not equal to").

 

[dupont]

Great @Joe4- thanks a bunch!

 

[Joe4]

You are welcome!