crap[ avering a column ignore text using that average in a new running average column.

=average(c1:index(c:c, match(9e307,c:c)))

Can you type a little slower and add some punctuation, capitalization, and white space?

That formula averages all of the numbers in col C. It that doesn't work, post a workbook.

@ shg, given the OP's version (using gunmeric for linux, which is compatable with ms excell - which I have never heard of), do you think that formula will still work?

I consulted the manual for gnumeric and could find nothing that would indicate that the formula given by shg wouldn't work.

Can you supply a file in Excel (xlsx or xls if you can't do xlsx) format from Gnumeric so that we can see what is happening. The manual says that you can do this.

Directions:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Ron, I did not meant that if the AVERAGE() function would work, but the wat that shg arrived atthe range...
=average(c1:index(c:c, match(9e307,c:c)))

That is far more complex that just a regular =AVERAGE(A1:G10) kind of formula, there may be a compatability issue

Hi Ford, I scanned the Gnumeric manual for Average, Index and Match functions. The information was "sketchy" but nothing to indicate that they don't work as we are used to them but their language is somewhat different than what I am used to. My "gut feeling" is that the INDEX/MATCH isn't exactly what we are used to, hence the compatibility issue that you mention. Average seems to be straight forward with a defined range as you show.

The OP should be able to save as an Excel file and that would show what is going on...I think.

Agreed, although if there is a compat issue, it may not show up when you load teh file into excel itself

And maybe Average, Index and Match is compat, but mixing them up like c1:index(c:c....

When a program says that it is compatible, just how compatible is it really?

maybe that is deteremined on how compatable the compatability testing is

There is a "running average" function in that program that might suit you well. It might be worth taking a look at especially if it will take an expanding range like $a$1:a1 that expands as it is filled down the worksheet.

Good luck with your project.