Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 13 Aug 2016 22:57:01 +0200Sum column A when something is in column Bhttps://ask.libreoffice.org/en/question/75076/sum-column-a-when-something-is-in-column-b/ I have two colum, the first one have number on it and the second one have some cell filled.
how could i do a conditional somme instruction for calculating only number that have a corespondiong not empty cell?
Had not found how to do that complexe function :(Sat, 13 Aug 2016 19:48:05 +0200https://ask.libreoffice.org/en/question/75076/sum-column-a-when-something-is-in-column-b/Answer by mark_t for <p>I have two colum, the first one have number on it and the second one have some cell filled.</p>
<p>how could i do a conditional somme instruction for calculating only number that have a corespondiong not empty cell?</p>
<p>Had not found how to do that complexe function :(</p>
https://ask.libreoffice.org/en/question/75076/sum-column-a-when-something-is-in-column-b/?answer=75086#post-id-75086Where A1:A5 contains the numbers and B1:B5 the are cells to be not empty.
=SUMIF(B1:B5,"<>",A1:A5)Sat, 13 Aug 2016 22:57:01 +0200https://ask.libreoffice.org/en/question/75076/sum-column-a-when-something-is-in-column-b/?answer=75086#post-id-75086