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: [email protected]
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
