|I am a long-time advanced user of Excel and have never encountered this error, hope someone can help.|
In column B, I have a formula that simply sums the contents of cells above. I copy/pasted (actually used the crosshairs to drag the formula across) that formula to adjacent cells, so that the sums of C, D, etc. would also calculate. Although the formula bar shows the correct formula for each column using the relative cell addressess (ex: =SUM(B4:B26) for column B, =SUM(C4:C26 for column C), the numerical result displays only the calcuated answer for the first column (ex: 97 shows across the board for all column sums, but if I individually type in the formula for each column it would calculate correctly).