Friday, September 30, 2011

yogi_Add Practice Sessions Attendance

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