From: "David Biddulph" groups [at] on 2 Mar 2010 03:52 I think you mistook some of the OP's colons for commas, Biff. -- David Biddulph "T. Valko" wrote in message news:OO03oCbuKHA.796(a)TK2MSFTNGP05.phx.gbl...> If you only have a "few" cells to check: > > =(A1=1)+(A5=1)+(A7=1)+(A15=1)+(A18=1) > > If you have "many" cells to check it depends on the range of numbers that > the cells can contain but you use something like this if the lowest > possible number is the number 1: > > =INDEX(FREQUENCY((A1,A5,A7,A15,A18),1),1) > > -- > Biff > Microsoft Excel MVP > > > "Marty" wrote in message > news:13F15110-BC01-4408-AA7A-FDC8BB5F21B9(a)microsoft.com... >> How do I use the countif on non-concecutive cells, i.e. I want to know >> the >> number of certain cells in worksheet that contain a specific value. For >> instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1. >> -- >> Marty > > From: T. Valko on 2 Mar 2010 12:03 Yes, I can barely see to read anymore late at night! Sitting in front of a computer monitor all day long is not good for your eyesight! -- Biff Microsoft Excel MVP "David Biddulph" wrote in message news:jZCdnR8P7sgvTBHWnZ2dnUVZ7sKdnZ2d(a)bt.com...>I think you mistook some of the OP's colons for commas, Biff. > -- > David Biddulph > > > "T. Valko" wrote in message > news:OO03oCbuKHA.796(a)TK2MSFTNGP05.phx.gbl... >> If you only have a "few" cells to check: >> >> =(A1=1)+(A5=1)+(A7=1)+(A15=1)+(A18=1) >> >> If you have "many" cells to check it depends on the range of numbers that >> the cells can contain but you use something like this if the lowest >> possible number is the number 1: >> >> =INDEX(FREQUENCY((A1,A5,A7,A15,A18),1),1) >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Marty" wrote in message >> news:13F15110-BC01-4408-AA7A-FDC8BB5F21B9(a)microsoft.com... >>> How do I use the countif on non-concecutive cells, i.e. I want to know >>> the >>> number of certain cells in worksheet that contain a specific value. For >>> instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1. >>> -- >>> Marty >> >> > First  |  Prev  |  Pages: 1 2 Prev: Pivot Table 'Validation'?Next: printing a report