I have a spread sheet that I use to keep stats for a locally run dart league

http://prodarts.homestead.com/excel-help.html
is where the example is, sorry about that
also, the addtional weeks need to land between "rows 423 and 425"

Hi Darts, welcome to teh forum and happy new year

without seeing a sample of your workbook, its hard to offer suggestions.

However, instead of adding rows to the bottom, add them to 1 row above the last row, by inserting a row 1 above the last row (hope that made sense?) doing that will automatically adjust the formulas and references.

I would suggest adding 1 blank row to begin with, then copying the data in the last row, to that row. then leave that "last" roe blank at all times, then just add an extra row above that "last" row when you need to add new data.

an alternative would be to convert the "table" to a TABLE, using insert/table.

if this doesnt work for you, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Can you upload the file here please? some of us (myself included) are not able to download files from other web sites (work firewalls and stuff)
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi

Use Simif instead Sum. That what course the problem.

Please click on attachment of 30 week.

Cheer

Originally Posted by dartsincanada

thank you so much for your help, unfortunately week 30 doesn't calculate the bonus points row 748 is empty, where as row 723 has the caluclation in it, how do I fix this

Hi
Grand total bonus point is on row 749 for week 1 to week 30. Row 748 is empty that for week 30 only for count row 727 to 747!!