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:

A	B
1	1.2
1	213
1	< 1.0
1	< 1.0
1	213
1	0.0014
1	0.0109
1	4
0.001	0.00045
0.003	0.1
0.003	2
0.005	0.074
0.003	0.08
0.003	< 0.000020
0.015	< 0.000020
0.0001	< 2.0
0.0001	< 0.000050
0.0005	< 0.000050

<tbody>
</tbody><colgroup><col><col></colgroup>

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!