Forum Discussion
Put =SUM in every other cell.
To save me the trouble of deleting every other cell with a =SUM total in it, I want the formula where i can drag the cursor along a line and it skips every other cell.
Perhaps you mean
=IF(D$1="Pts",SUM(D2:D12),"")in D13 and drag it to the right. Same for other rows with total.
In Totals sheet you may use INDEX/MATCH to pickup sums from Mavan Teams sheet, but I'm not sure what is the logic for different Totals tables.