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?

What does +ve mean? Cumulative?

In this case it means positive, i.e. B=C

Pete

On Jun 19, 3:02*pm, Dave O wrote:
What does +ve mean? Cumulative?

Sorry, was using short form to represent the word positive. :-)

Can anyone help?

"Dave O" wrote:

What does +ve mean? Cumulative?

=COUNTIF(A1:A23,"0")


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 18:49:01 -0700, andrew
wrote:

Sorry, was using short form to represent the word positive. :-)

Can anyone help?

"Dave O" wrote:

What does +ve mean? Cumulative?