"Ken99" wrote:

I have a spreadsheet with a number from 1-20 in column A for each record
(row). I have another number in column P representing a number of days for
each record. I need a summary formula which does the following:

For all the rows in column A that are less than 11 (have values from 1-10),
average all of the matching rows in column P.

Thanks Bob--this was right on and solved the problem immediately.

--Ken