Excel 2007
I have a worksheet with columns labelled B-AU (B1:AU1).
Rows are labelled 1-450 (A2:A452).
The contents are either 0 or 1.

I'd like to be able to count the number of 1's and block them- with the
outpu being for example rows 1,4,6,7,300,234 present in columns B,C,D,AB,X
workng from only present in one column to present in all.

Is this possible? Any help would be much appreciated.

Regards

I would use a formula. Put into cell A455 the following formula

=countif(A2:A452,1)

Then copy formula to B455,C455,D455,AB455,X455

"matty" wrote:

Excel 2007
I have a worksheet with columns labelled B-AU (B1:AU1).
Rows are labelled 1-450 (A2:A452).
The contents are either 0 or 1.

I'd like to be able to count the number of 1's and block them- with the
outpu being for example rows 1,4,6,7,300,234 present in columns B,C,D,AB,X
workng from only present in one column to present in all.

Is this possible? Any help would be much appreciated.

Regards