MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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

Type 0 in A3.
Type in B2


Type in B3


Type Patrick in A5.

Type in B4


Type in A6

=A5&" smiles"

Type in B5


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