2018-03-19 22:48 GMT+01:00 Johnny Rosenberg <gurus.knu...@gmail.com>:
> 2018-03-19 21:52 GMT+01:00 John R. Sowden <jsow...@americansentry.net>:
>
>> I had this working, then I noticed that it is no longer working (no error
>> messages).
>>
>> Sums any cells in col F if there is a 2211 2212 or 2213 in col M:
>>
>> =SUMIF(M6:M351,"2211|2212|2213",F6:F351)
>>
>
> Are you sure this is supposed to work? I can't find any examples like this.
>
> However, this works:
> =SUMIF(M6:M351,2211,F6:F351) + SUMIF(M6:M351,2212,F6:F351) +
> SUMIF(M6:M351,2213,F6:F351)
>
> This also works:
> {=SUM(SUMIFS(F6:F351;M6:M351;{2211;2212;2213}))}
> (it's a matrix formula, so enter everything except the surrounding {},
> then hit Ctrl+Shift+Enter rather than only Enter)
>
Oops… I meant it's an ARRAY formula. It's ”matrisformel” in my language, so
I accidently translated ”matris” to ”matrix”, which seems like a good idea,
but there are a lot of words that look like they mean something while they
really mean something quite different… for instance, my language's word
”semester” means vacation and there are a few more examples of words that
also likely could cause some confusion… :P
Kind regards
Johnny Rosenberg
>
>
> Kind regards
>
> Johnny Rosenberg
>
>
>> it now gives a result of zero.
>>
>> I tried changing the format of the searched col to text or general
>> number, no change
>>
>> I have set the justification to 'centered'. Since the title is greater
>> that the width of the 4 characters,
>>
>> there is a space before and after the 4 characters, but I think this
>> should be for display only, name changing the data.
>>
>> Turning off centered justification, etc. makes no difference.
>>
>> Help?
>>
>> John
>>
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
>> subscribe/
>> 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
>>
>
>
--
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
