Adding set rows

[alanpaulwilson]

Hi Everyone

Does anyone know a formula that will add every, say, 10th cell in a
row, instead of typing in, say. +a10+a20+a30 etc.

Thanks

 

[andycat]

If there is another column that has a key identifier (unique to the rows you
want added), you could use the SUMIF formula.

e.g.., SUMIF(b1:b100,"include",a1:a100). In this example, all values in a1
through a100 would be summed if the word "include" was in the corresponding
cell in column b.

If, however, your question is related to adding subtotals -- that is, rows
1-9 are detail, and 10 is a subtotal, 11-19 are detail, and 20 is a
subtotal, etc., then you could simply use the SUM formula to add all rows
and then divide by 2.