average of first 10 numbers in row

[ardbegneat]

hi all, first post here, so thanks in advance for the help....I'm sure there is an easy an obvious solution, but I've been out of practice with Excel for several years now. FYI, if it matters I'm using Excel 2003. I need help with a formula to average the first 10 numbers in a row. Once a month, a new column will be inserted at column C, so that the most recent set of numbers is in C and reads left to right. I am attaching an example of my worksheet, if that helps. Thanks again.

[outofthehat]

If you just want to take a simple average, then you can use
=AVERAGE(OFFSET(B2,0,1,1,10))
The offset function uses the start cell B2, 'moves' no rows and 1 column, and selects a range 1 row high by 10 columns wide. Therefore, it will always 'start' at column C.
However, check the help files for the difference between AVERAGE and AVERAGEA...

[ardbegneat]

thanks for the reply, I didn't mention it in my original post (but was on the w.s. I attached) that some cells contain the text "DNP". What I need the formula to do is skip the cells with "DNP" and average out the first 10 numbers left of column B.