Sure. B C D E Red 8 XL IN Red 9 L PO Red 10 Red 11 XL IN Red 12 L OUT
First line is the column. In column B I have all the jersey colors. There are currently 12 colors. Column C is the number on the jersey. Column D is the size of the jersey. You'll notice that Red #10 has no size. That jersey has been lost and will need to be replaced. Column E has one of these designations: IN, OUT, PO, Replace, ? So, Red #8 jersey is a XL and is currently in inventory. Red #9 size L is PO. Red #10 has either been lost or otherwise missing and will be replaced (though since I copied and pasted the data here, it currently says nothing). Red #12 is size L but is currently checked out. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Jul 15, 2016 at 6:24 AM, Bruce Hohl <bruceh...@gmail.com> wrote: > Can you give some examples of the cell contents of column E when a PO is > present and not present. > > On Fri, Jul 15, 2016 at 7:03 AM, Wade Smart <wadesm...@gmail.com> wrote: >> >> -- >> Registered Linux User: #480675 >> Registered Linux Machine: #408606 >> Linux since June 2005 >> >> >> On Thu, Jul 14, 2016 at 8:01 PM, Bruce Hohl <bruceh...@gmail.com> wrote: >> > Perhaps one of these depending the content of Column E: >> > =COUNTIFS(E2:E160,"<>PO", B2:B160,"Red", D2:D160,"M") >> > =COUNTIFS(E2:E160,"", B2:B160,"Red", D2:D160,"M") >> >> The first one produces 4 and the second one produces 0. > > -- To unsubscribe e-mail to: users+unsubscr...@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