Re: [libreoffice-users] If value is not present, count it.

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 <wadesmart@gmail.com> 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: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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