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 the corresponding values in column D.
Thank you, I will certainly be kept in my personal FAQ file.
Assuming labels are in A1:A30, values in B1:B30
=SUMIFS(B1:B30,A1:A30,"=<text>",B1:B30,">0")
replace <text> 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
necessary, hidden) column:
Assuming original labels in A1:A30, values in C1:C30
cell B1 formula: =LEN(IF(ISERR(FIND("<text to look for>",A1)),"",A1))
(copy this formulas through B30)
then
=SUMIFS(C1:C30,B1:B30,">0",C1:C30,">0")
--
To unsubscribe e-mail to: users+unsubscr...@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/
All messages sent to this list will be publicly archived and cannot be deleted