I have two set of tables:

Table #1: (updated twice a week)
A B C
FD 1 1
FD 1 2
FD 2 2
FD 2 1
FD 2 1

What is the best formula to count if column B = 2, and B-C = +ve result,
then count the latest number of +ve result. (per table, result is 3).
Assuming that a new row is updated with the following (column A=FD, column
B=1, column C=2) then the formula cell will now count as 0 (due to -ve
result).


Table #2: (updated fortnightly)
A B C
FD 1 1
EA 1 2
FD 1 2
FD 2 1
FD 2 1
EA 2 1

Can i use LOOKUP to count if "FD" appears, check if B-C = +ve result then
register the number of times it returned a +ve value? In table #2 above,
formula should show 2 times. However, assuming that a new row is updated with
the following data (column A="FD", column B=1, column C=2) which results in a
-ve value then the formula cell will show 0 (zero).

Suggestions?