I have row C3, then row C7, row C11, row C15, row C19, there is a space of 4 rows for the rows I wish to add. If I was adding all rows C3 to C19, the formula would be =Sum(C3:C19), if I added a row C23, this would automatically adjust the formula making it =Sum(C3:C23). To add the odd rows the formula could be , =Sum(C3,C7,C11,C15,C19) or =Sum(C3+C7+C11+C15+C19). If I add row C23, it does not adjust the formula to include it. Is there a formula where you can use the =Sum and have a step of how many rows to miss before it picks up the row to be added. I hope this makes some sense.
kevsim
kevsim
