So I have a column in excel that I want to roll up into one row. Essentially the column has a `0`

if a feature isn't present, and a `1`

if it is.

What I want to do is get excel to check a column, lets say `B2:B30`

, and, if there is a `1`

in any of those rows to show a `1`

in `B1`

. If there is a `0`

in all the rows, then I need it to show a `0`

.

Looked at lots of stuff online, and I can get it to count the number of rows with a certain number (or just use a pivot table), but I can't get it to roll up and just show a simple `0`

or `1`

.

Any help would be great.