*Yogi Anand, D.Eng, P.E.*Google Spreadsheet

*www.energyefficientbuild.com*

*a user asked:*

*Help with conditional values.*

*So I have an attendance sheet for team practice and I'm trying to calculate the total number of practices, and each individual's percentage of attendance. I am trying to do that with out having to manually change the total practices field after each practice. What I'm trying to do is check to see if a range has any value >0, and then add it. So that when I put a 1 in the new practices column marking attendance, the total practices field updates automatically.*

*I've tried using if statements, but that doesn't seem to be working at all. I've tried using count, but I can't get it to work for me. I haven't used a spreadsheet in a while so I'm pretty rusty. Any help would be great.*

*C D E F G H*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 0 0 0 0 0*

*1 1 0 0 0 0*

*1 1 0 0 0 0*

*1 0 0 0 0 0*

*1 1 0 0 0 0 Total Practices : 2*

----------------------------------------------------------

In the following I have proposed formulas for

- formula for row by row computation
- array formula for fixed number of Practice sessions
- array formula for dynamic range of Practice sessions
- array formula for open ended range of Practice sessions