Re: [libreoffice-users] function sumif question

On 04/21/2016 03:43 PM, Piet van Oostrum wrote:
> John R. Sowden 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
>
> You could use a regular expression for the criterium. You will have to enable regular expressions 
> in formulas.
>
> =SUMIF(B5:B10;"1234|2345|6789";A5:A10)
>
> Look in the Calc Guide.
Thank you all.  It worked. By the way Regular Expression is on by 
default, as I would not have touched it as I didn't know what effect it 
would have.  Your responses open up more possibilities!

John



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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