well i think i got it working but when i ctrlD the function it works for the first few, up until the A# gets out of range of 8/1..is there a way to copy a formula all the way down to read just the sum?