Forum Discussion
copying the @sum formula gives values in certain columns
This just started happening a couple of days ago - and only on one workbook - but on multiple sheets. When I copy a simple @sum formula across columns, some of the columns calculate correctly, some ...
Sergei - thanks - I will check for circular references and if that doesn't work, attach the files
Yes- just rechecked - all $ format - it only seems to be columns U - V - W - X - Y - all other columns work - and only on certian rows when I copy/past - its shown up on other sheets of the same workbook
Could you show how the formula looks like for one of yellow cells and for another one with correct result (what do you see in formula bar)?
Here is the formula in the cell I am pasting from
=SUM(S10:S19)
and here is the formula in one of the yellow cells
=SUM(V10:V19)
And these formulas are in row #20?
