How to SUM a filtered column of figures in ODS sheet

[ablehandy]

For club accounts I require to correctly SUM a column of figures previously filtered for a particular expense type. Previously used Microsoft Excel
would correctly total only the filtered cells, in ODS sheet filtering appears to be ignored giving a false total.
Is there a way around this please?

AbleHandy, Nottingham UK

[FJCC]

You can use SUBTOTAL().

Code: Select all

=SUBTOTAL(9;B2:B100)

where 9 signifies the SUM function. Check out the help on that function. A pivot table might also be a good solution, depending on what you are doing.

[ablehandy]

Thanks will try out later