1st time pass rate percentage?

[Berty25]

Hi again,
this is pretty much a follow up from previous post but wanted to add new pic of how its set up so you can understand what i'm getting at.
As you found last problem so easy, is it possible i could set up a first time pass rate with how i got spreadsheetpass rate first time.xls?
All i want to be able to do is divide how many people have passed first time with how many people have passed.
I've tried jigging it about with formula i was given but it taking fails into account? i tried this thinking it would work, but no.
=COUNTIF($B$2:$B$1000,"pass 1st")/COUNTA($B$2:$B$1000,"pass") but
What formula would do the job
Any help or advice again much appreciated?

[zbor]

COUNTA($B$2:$B$1000,"pass") will count you everything in $B$2:$B$1000 + 1 (word pass counted once).

You probably want:

Please Login or Register  to view this content.

[Berty25]

COUNTA($B$2:$B$1000,"pass") will count you everything in $B$2:$B$1000 + 1 (word pass counted once).

You probably want:

Please Login or Register  to view this content.

You guys are the best!!
Thanks you very much just the job, really appreciate it