James, Le 14/01/2020 à 00:10, James a écrit :
[...] 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.
check the SUMIF() function which should give the answer you're looking for. Best, -- Jean-Francois Nifenecker, Bordeaux -- 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