please take note of the changes.

"Chris" wrote:

I need to average a group of data with a criteria but only up to a certain
number.

Sample:

CD AG CD FG CD FG AG

Sales 50 20 10 30 60 40 80

Expense 30 10 60 20 70 90
50

I need to average the data that is under "CD" and only those in the 2nd row(expense) but ONLY the first 2..(30 and 60).
How can I set the limit??