Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
On 01/12/2017 21:57, T. R. Valentine wrote: I messed up. Should be: Thank you for the correction. The formula, with a little amendment works flawlessly. =SUMIFS($D$7:$D$1000,$C$7:$C$1000,"=Sold",$D$7:$D$1000,"<0") With this formula I can now search for a certain string in column C and SUM

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread T. R. Valentine
I messed up. Should be: Assuming labels are in A1:A30, values in B1:B30 =SUMIFS(B1:B30,A1:A30,"=",B1:B30,">0") replace with the 'certain text string' - unless you are looking for a text string within the contents of the cells with text. That would be more complicated. I'd go for a (if

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread T. R. Valentine
On 1 December 2017 at 13:25, Hylton Conacher (ZR1HPC) wrote: > I have two adjacent columns where the first contains text and the second > contains 9 digit numbers both above and below zero. > > I would like to SUM the contents of the second column provided it meets two

[libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
Hi, I have two adjacent columns where the first contains text and the second contains 9 digit numbers both above and below zero. I would like to SUM the contents of the second column provided it meets two criteria, namely that the first column contains a certain text string and the number