Prev: Pulling out invoices that do not match
Next: In a formula, how do I set a maximum acceptable value?
From: bob on 5 Mar 2010 20:24 Column E2:E61 contains only numbers between 1 and 3. In E62, I want a formula that will tell me the number of times both 0 and 2 appear in the column. Example Column E Row 2 0 Row 3 1 Row 4 3 Row 5 1 Row 6 2 Row 7 0 Row 8 1 etc. In this example, the formula would return a value of 3 because 0 and 2 appear a total of 3 times. Thanks, Bob
From: T. Valko on 5 Mar 2010 21:02 One way... =COUNTIF(E2:E61,0)+COUNTIF(E2:E61,2)  Biff Microsoft Excel MVP "bob" <bob(a)discussions.microsoft.com> wrote in message news:453DB4503F004DED81FC7E58755EAD0F(a)microsoft.com... > Column E2:E61 contains only numbers between 1 and 3. In E62, I want a > formula that will tell me the number of times both 0 and 2 appear in the > column. > > Example > Column E > Row 2 0 > Row 3 1 > Row 4 3 > Row 5 1 > Row 6 2 > Row 7 0 > Row 8 1 > etc. > > In this example, the formula would return a value of 3 because 0 and 2 > appear a total of 3 times. > > Thanks, > Bob
From: JLatham on 5 Mar 2010 21:32 for E62: =SUM(COUNTIF(E2:E61,{0,2})) Response inspired by Gord Dibben <g>. "bob" wrote: > Column E2:E61 contains only numbers between 1 and 3. In E62, I want a > formula that will tell me the number of times both 0 and 2 appear in the > column. > > Example > Column E > Row 2 0 > Row 3 1 > Row 4 3 > Row 5 1 > Row 6 2 > Row 7 0 > Row 8 1 > etc. > > In this example, the formula would return a value of 3 because 0 and 2 > appear a total of 3 times. > > Thanks, > Bob

Pages: 1 Prev: Pulling out invoices that do not match Next: In a formula, how do I set a maximum acceptable value? 