MrExcel Publishing
Your One Stop for Excel Tips & Solutions

averages


Posted by Patrick on January 15, 2001 5:54 PM

i want to average a column, however i would
like the average not to include the cells
which do not have an entry yet........
just starting out...smiles


Posted by Aladin Akyurek on January 16, 2001 3:18 AM

Type 4 in A1, 5 in A2.

Type in B1
=AVERAGE(A1:A2)

Type 0 in A3.
Type in B2

=AVERAGE(A1:A3)

Type in B3

=average(A1:A4)

Type Patrick in A5.

Type in B4

=AVERAGE(A1:A5)

Type in A6

=A5&" smiles"

Type in B5

=AVERAGE(A1:A6)

Compare the behavior of AVERAGE on different sets of values in column A that you entered and conclude.

Aladin