i'll try to explain best i can....
i have 3 colums, first and second are put in and the third is the difference
between them. then on the bottom, i have the averages. i know how to do the
subtraction, but for the other rows below keep showing "0" even though and
the averages are now correct. how can i keep that column to automatically
show the difference without always having the zero there and not having to
always put that function in that box.

here is what i looks like

# DATE COURSE SCORE PAR (+/-)
1 04/03/10 49 37 12
2 04/03/10 43 34 9
3 04/19/10 44 36 8
4 0
5 0
6 0
7 0
8 0
9 0
0

AVERAGE 45.33 35.67 1.38

hi
the usual way of doing this is to use an if formula
=if(C2-D2=0,"",C2-D2)
copy down as far as needed.
if there is no data in C or D then the cell with the if formula will show
as blank.
the average formulas will ignore the "blank" cells and calculate only on
cells that show data.

regards
FSt1

"bb" wrote:

i'll try to explain best i can....
i have 3 colums, first and second are put in and the third is the difference
between them. then on the bottom, i have the averages. i know how to do the
subtraction, but for the other rows below keep showing "0" even though and
the averages are now correct. how can i keep that column to automatically
show the difference without always having the zero there and not having to
always put that function in that box.

here is what i looks like

# DATE COURSE SCORE PAR (+/-)
1 04/03/10 49 37 12
2 04/03/10 43 34 9
3 04/19/10 44 36 8
4 0
5 0
6 0
7 0
8 0
9 0
0

AVERAGE 45.33 35.67 1.38

Another method is to untick the show 'zero in a cell' option.
Check out help in your version of Excel

"bb" wrote:

i'll try to explain best i can....
i have 3 colums, first and second are put in and the third is the difference
between them. then on the bottom, i have the averages. i know how to do the
subtraction, but for the other rows below keep showing "0" even though and
the averages are now correct. how can i keep that column to automatically
show the difference without always having the zero there and not having to
always put that function in that box.

here is what i looks like

# DATE COURSE SCORE PAR (+/-)
1 04/03/10 49 37 12
2 04/03/10 43 34 9
3 04/19/10 44 36 8
4 0
5 0
6 0
7 0
8 0
9 0
0

AVERAGE 45.33 35.67 1.38

hi
true but that wont stop the average formula from counting the zero in it
average.

regards
FSt1

"Ron@Buy" wrote:

Another method is to untick the show 'zero in a cell' option.
Check out help in your version of Excel

"bb" wrote:

i'll try to explain best i can....
i have 3 colums, first and second are put in and the third is the difference
between them. then on the bottom, i have the averages. i know how to do the
subtraction, but for the other rows below keep showing "0" even though and
the averages are now correct. how can i keep that column to automatically
show the difference without always having the zero there and not having to
always put that function in that box.

here is what i looks like

# DATE COURSE SCORE PAR (+/-)
1 04/03/10 49 37 12
2 04/03/10 43 34 9
3 04/19/10 44 36 8
4 0
5 0
6 0
7 0
8 0
9 0
0

AVERAGE 45.33 35.67 1.38