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.
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy