can anyone please help me???

[LMF]

I have tried methods that i know, but it doesn't work, so i hope there is an expert with this who can help me out with this bit!
ok, i got two column with these data:

Round Pos
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 10
1 Incompleted
1 Incompleted
1 Incompleted
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 Incompleted
2 Incompleted
2 Incompleted

I want the number of ppl with a Position (mean every1 except those who incompleted it). for round both round 1 and 2.

So the experted result is :

Round 1 10 ppl finished it
Round 2 8 ppl finished it

but of course i need to do this excel, can anyone pls teach me how i can do this please?

please help

 

[LMF]

Yogi, your formula is also useful to me, thank you very much for helping!



many thanks to all

 

[Yogi Anand]

On 2002-04-13 14:18, Ricky Morris wrote:
assuming that the data you're working with is in a range named "Data" try the following:

in cell F1 enter "Round"
in cell F3 enter "1"
in cell G1 enter "Round"
in cell G3 enter "2"
# of people finished in round 1 is:
=DMAX(Data,"Pos",F1:F2)

# of people finished in round 2 is:
=DMAX(Data,"Pos",G1:G2)

Hi LMF and Ricky:
If you wanted to use the D-functions ... then in cell F1 put Round; in cell G1 put Pos; in cell F2 put 1, in cell G2 put <>Incompleted
then the formula:
=DCOUNT(A1:B25,"round",F1:G2) will give 10; and when you put in cell F2 the value 2, it will give result for Round 2 of 8