Numbers odd rows

Hi edgewater,

This question was asked within the last couple of weeks, but the title/question didn't say what was going to be asked, making that post difficult for later users with the same question to find.

Here are two methods. Neither is the one offered in the post mentioned, but either will do the job.

Assumption: B79 or B80 is the last non-Footer row in your table.

Add a column to your table In my example, I've used column A, but you could place the extra row at the right end of the table) or anywhere convenient), and could hide it, if desired.

The table continues to row 80. All even rows have a value of 1 in column B, all odd rows contain a value of 3. Using these values, the result of summing odd rows should always be a multiple of 3.

A second method, similar in that it also needs an extra column, is to copy the vAlues in odd rows of B to the extra column (G in this example) the sum that column. In even rows, the formula inserts a null string—a text value, which appears 'blank', and which SUM interprets as zero.

Formula in G1: SUM(G)

If the assumption noted above is NOT true, you will need to change the column references from the column only to a specified range of cell in rows 2 t0 79 (or 80) of the specified column.

eg: SUM(G) would become SUM(G2:G79)

Regards,

Barry