See attached example for a few ways to solve this problem. On Thu, Apr 21, 2016 at 5:47 PM, John R. Sowden <[email protected]> wrote:
> I have an accounting ledger in calc, with two columns in question. > > col 1 is credit (amount charged to account) and col 2 is the account > number (a 4 digit number currently formatted a number with no decimal, but > not text). > > My objective is to sum the amounts in column 1 if col 2=1234. Not a > problem. Done. > > Now I want to sum the amounts in column 1 if the number in col 2 is 1234 > or 2345 or 6789) > I tried just putting the numbers in the sumif field, I tried putting them > in parentheses, and finally I tried the OR() function by making the > criteria field in sumif OR(1234,2345,6789). > > No dice. Two questions: > 1) what is the solution to my problem? > 20 Where can I go for more reference material than the help screen to > solve these little problems? > > thanks, > John > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
