Using countif on non-consecutive cells
in [Functions]
|
Prev: Pivot Table 'Validation'?
Next: printing a report
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" <biffinpitt(a)comcast.net> 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" <Marty(a)discussions.microsoft.com> 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" <groups [at] biddulph.org.uk> 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" <biffinpitt(a)comcast.net> 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" <Marty(a)discussions.microsoft.com> 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 >> >> > |