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
B1. If there is a
0 in all the rows, then I need it to show a
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
Any help would be great.