Get number of "non-sum-zero" columns

[ExcelStefan]

Hi,

I have a table which contains numbers. The table has between 1 and 8 columns (and a fixed number of rows). I need to find out how many columns it has. The number of columns is given by the last column which has a sum greater than 0 (or by the column number of the first column with sum equal zero, minus 1).

Does somebody have an idea to do this without VBA, e.g. with LOOKUP(SUM())?

Thanks!!