Make your own free website on Tripod.com

The Answer Machine

Excel Functions
Home | Space Information | The Planets | Excel Functions

 

 

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

copywrite 2005 TheAnswerMachine