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 corresponding to that text string in the second
column is greater than zero.
I have tried SUMIFS, AND with SUMIF and Vlookup but cannot seem to get
the formula correct i.e. the error seems to always be that there is a
missing operator in the string yet checking back I see all commas are in
the right places. I am placing the text to search for in quotation marks
as well as the "0<" or "0>"
Any help appreciated
Regards
Hylton
--
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