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" wrote in message news:453DB450-3F00-4DED-81FC-7E58755EAD0F(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 . "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  |