That is absolutely fantastic. I never knew that function was there.

Thank you very much.

MMH :)



"Dave Peterson" wrote:

I think I would get rid of those blank lines.

Then (with the data sorted by that column), use xl's built in
Data|Subtotals to get those values.

If you add extra rows of data, remove the subtotals, resort the data and reapply
the data|subtotals.

You may want to look at Data|pivottable, too.