Percentages

[witt1989]

This is a worksheet that I put together as an example of what I am looking ot do.


Weeks 1/26/09 1/12/08 1/5/09

Therapist 1 12 5 2 33.3% Compliant



What I am trying to do is convert the numbers above to show as a 0 if they are <=4 and show as a 1 if they are >=5. 0 = 100% compliant and a 1 = 0 % Compliant. I need the end of the row to calculate the average percentage based on the number of weeks. For example, Therapist 1 would show 33.3% compliant Can anyone help me on this one?
Kim

[Andy Pope]

To calculate the percentage you can use

=SUMPRODUCT(--(B3:D3<=4))/COLUMNS(B3:D3)

assumes the 3 values where in row 3.

[witt1989]

It isn't working for me. I should be typing it exactly in the tool bar? My field are B5-E5.. I am sooo new at this and getting frustrated easily

[Andy Pope]

See attached