Unfortunately that's a bit too simple.

What the message didn't show is that there are large gaps in between data. There's around 100 columns, of which only a few will have a 1 or a 0. I also need to count the 1s and the 0s.

Also I've found using SUMPRODUCT/COUNTIF etc that they work for small simple amounts of data, so I could do that for, say, each column and add them but I'm looking for a more eloquent solution.

I've also had problems differentiating between a 'gap' and a 0.

I'm guessing I need an array but, as with the SUMPRODUCT/COUNTIF etc I can't get it to work for a large table where it conditionally counts what is on certain rows.