Sleeping

School

Studying

Playing

other

Totals

what the formula is

Sunday

9

0

1

9

6

9

=MAX(B3:G3)

to determine the maximum or minimum of a range, highlight the range then go up to the sum symbol drop down arrow and click min or max

Monday

8.5

6

2.5

1

4

4

=countif(b4:f4,">2")

to count the number of filled in columns, just highlight the range you want to count, then click the down arrow on the sum symbol and choose count.  To count the number of occurances equal to (<, > etc.), use  = countif(range,"criteria")  Be sure and put quote marks around the criteria

Tuesday

2.95

9

2.5

1

2.75

18.19534

=sum(B5:G5)

to sum a range, highlight the range and an adjacent blank cell then click the sum sign in the toolbar