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")
On Thu, Jul 14, 2016 at 8:36 PM, Wade Smart <[email protected]> wrote: > This does not work but this is what Im thinking about. > > If a item in this range does not have PO, and is Red and is M > then I want to count it. > > =IF( $E$2:$E$160 <> "PO", > SUMPRODUCT($B$2:$B$160="Red",$D$2:$D$160="M")) > > This is for tracking our league jerseys and our inventory > to be checked out seasonally to the players. I want to know > how many of Medium shirts Red team has. > > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
