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

At 06:34 15/07/2016 -0500, Wade Smart wrote: B C D E Red 8 XLIN Red 9 L PO Red 10 Red 11XL IN Red 12L OUT With this data, my earlier suggested formula of =SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="M") gives the result zero, which

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

Its been pointed out that actually state my problem making it difficult for people help. Valid point. I have a spread sheet that tracks jersey inventory. Column B = Jersey Color Column C = Number printed on the Jersey Column D = Jersey Size Column E = Status of the jersey IN, OUT, PO,

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

=SUMPRODUCT($E$2:$E$160="PO",$B$2:$B$160="Red",$D$2:$D$160="L") This = TRUE. There is only 1 PO and it is a Large. If D column is set to M for medium, the value is FALSE. This one =SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="L") also = TRUE. There are Large Red jerseys without

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

4 = the total number of M shirts for Red. So this =SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="M") is not matching the first section. Maybe <> doesnt work on text? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Jul 15, 2016 at

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

Sure. B C D E Red 8 XLIN Red 9 L PO Red 10 Red 11XL IN Red 12L 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

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

At 19:36 14/07/2016 -0500, Wade Smart 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")) Just:

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 wrote: > This does not work but this is what Im thinking about. >