Hi James, you can use the function SUBTOTAL. https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633 Kind regards Regina James schrieb am 14-Jan-20 um 00:10:
I've got a spreadsheet of all my bank transactions and I want to filter them by type and them the results.eg. Tran Type Amount 1 A 1.5 2 B 2.0 3 A 3.5 I can use Data/More Filters/Standard Filer to get: Tran Type Amount 1 A 1.5 3 A 3.5 but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got.