ExcelBanter - Advance filter count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Advance filter count (https://www.excelbanter.com/excel-discussion-misc-queries/184668-advance-filter-count.html)

Advance filter count

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

Advance filter count

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