Try something like this in G4:

=ROUND((COUNTA(B4:C4)+(COUNTIF(D4:F4,"<")0)*1)/3,2)

then copy it down.

Hope this helps.

Pete

On Sep 14, 8:28*pm, Newfie809 wrote:
A * * * B * * * C * * * D * * * E * * * F * * * G * * * H
* * * * 1 * * * 2 * * * 3 * * * 4 * * * 5 * * * 6 * * *
* * * * Section Section * * * * * * Section * * * * * * * * Section * * * * Total
Name * * * *1 * * * 1 * * * * * * * * * *1 * * * * * * *1 * * *
Teacher 1 * * * ENG3U1 *ENG3U1 * * * * *ENG1D1 * * * * * * * * *1.00
Teacher 2 * * * CGC1D1 *CGC1D1 *HFN2O1 * * * * * * * * * * * * *1.00
Teacher 3 * * * ESLAO1 * * * * *ATC4M1 * * * * *ATC4M1 * * * * *0.67
Teacher 4 * * * AMQ3O1 * * * * *AMG3O1 *AMI2O2 *AMI2O2 * * * * *0.67
Teacher 5 * * * AMQ4M1 * * * * * * * * * * * * * * * * * * * * *0.33
Teacher 6 * * * MPM2D1 * * * * * * * * * * * * * * * * *MCF3M1 *0.67

It takes three sections to equal 1.0 * * * * * * * * * * * * * *
Do you know a formula that would count sections and return it to a number * * *
for each Teacher, and columns 3/4/5 are only one section * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Teacher 1 should be 1.0 * * * * * * * * Rounding Down
Teacher 2 should be 1.0 * * * * * * * * * * * * * * * *
Teacher 3 shouls be a .67 * * * * * * * * * * * * * * * * * * *
Teacher 4 should be a.67 * * * * * * * * * * * * * * * * * * * *
Teacher 5 should be a .33 * * * * * * * * * * * * * * * * * * *
Teacher 6 should be a .67 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Would someone know how to do these formulas?????????????