Microsoft Excel question

[TheGrandHooHa]

Hi all

I have a question about some number crunching in Excel. If I have a column of numbers that looks like this:

1
4
3
k
1
n
3

How do I get a field at the bottom of the column to display an average of ONLY the numbers (i.e., so that it disregards the k's and n's)?>

Thanks,
TGHH

 

[saym]

What version of Excel are you using? I'm on 2000 and =average(a1:a7) works for me.

 

[TheGrandHooHa]

Woops! Duh me... I had screwed up a value earlier in the sheet.

Thanks for the reply anyway, saym.