Exel

Hello Julie

Thank you for your question and welcome to the forum.

The SUBTOTAL function can be used to create totals, averages etc with filtered data.

To use the function, enter it in when the data is unfiltered; then when you apply a filter you'll find that the result changes.

Use the Insert Function button (fx next to the formula bar) to insert the function SUBTOTAL, using the Help with this function link to see how it works.

Kind regards
Amanda