Please Help! :o) I'm drawing a blank on how to create a formula that will
give you the percent passing on a row of data that has either pass, fail or a
blank space.

Is there any way to create an IF statement for the calculated percentage?

Here's an example:
Date 1st shift 2nd shift
6/1/09 pass pass
6/2/09 pass fail
6/3/09 pass
6/4/09 fail fail
6/5/09 fail

And it will be calculated per week of data.

I thought about giving pass a value of 100 and fail a value of 0, but I
don't know if that would really solve anything.

Any hints or assistance would be fabulous!

Moriah