Re: [libreoffice-users] Problem with the sumif function

2018-03-19 21:52 GMT+01:00 John R. Sowden <jsowden@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)



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+unsubscribe@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+unsubscribe@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