i have 300 rows
each row has 12-60 columns of data in it, but each row has a different starting column . i need to create a new column, B, and put the sum of the first 12 columns with data into it.
must ignore cells that have just a "0" in it.
for example, row 25, has 0 in columns 12-34. So I need column B to equal the SUM of B35-46