Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

At 06:34 15/07/2016 -0500, Wade Smart wrote:
B     C     D     E
Red 8     XL    IN
Red 9     L      PO
Red 10
Red 11    XL   IN
Red 12    L      OUT

With this data, my earlier suggested formula of
gives the result zero, which appears to be what you need.

Job done?

At 06:38 15/07/2016 -0500, Wade Smart wrote:
4 = the total number of M shirts for Red.
So this
is not matching the first section.

There are no Ms at all in your sample data. No-one can see four Red Ms and no-one can see if they have "PO" or not, so no-one can guess what you are doing wrong.

Maybe <> doesn't work on text?

Of course it does. My old friend William of Ockham tells me you shouldn't think this way.

At 06:52 15/07/2016 -0500, Wade Smart wrote:
This = TRUE.

No, it cannot be TRUE, since SUMPRODUCT() returns a numerical value, not a Boolean. Have you - inappropriately - set the format for the result cell to "Boolean value"?

There is only 1 PO and it is a Large.

"L" is not the same as "Large", of course.

If D column is set to M for medium, the value is FALSE.

Again, SUMPRODUCT() cannot give the result FALSE.

This one
also = TRUE.

Set the format of the result cell to a numeric one.

There are Large Red jerseys without PO but it doesn't count them.

I cannot see those.

You sent me a private message, which I therefore replied to privately. I suggested there that one problem could be that some of your cells that appear to be "OP" or "Red" or whatever actually contain something different - perhaps just having trailing spaces.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.