You can do this w/o VBA and with a (relatively) simpler formula.

Suppose your data are in A1:A13, the average is in D1 and the std.
dev. in E1. Then, use the array formula
=AVERAGE(IF(ABS(A1:A13-$D$1)<=$E$1,A1:A13))

To enter an array formula complete data entry not with the combination
of SHIFT+CTRL+ENTER keys and not just the ENTER or TAB key. If done
correctly, *Excel* will show the formula enclosed in curly brackets {
and }

On Thu, 15 Oct 2009 10:09:08 -0700 (PDT), lawdoggy
wrote:

I'm trying to average only the numbers that fall within the standard
deviation. Say you have 10 numbers listed and only 7 fall in the range
of the standard deviation of the list. I need the average of only
those number that fit. I've tried several different ways but nothing
is working. Any help would be greatly appreciated!!

Thanks...mitch
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins