Forum

Ah, it's a Pivot Table. I think you can "subtotal" by average - that is, the group subtotal is actually an average.

Hi Paul Without the file, I'm guessing at what you're trying to do. I imagine you have a table with n rows for n rental units, a column for rent (e...