G
Guest
In cell d6 I am summing together d1:d5 using =sum(d1:d5).
it does not calculate correctly unless I type in the cell and F9 it.
Further, when I drag the formula right despite the next cell saying
=sum(E1:E5) it is returning the value of column D.
Any idea why the sum is not refreshing and why the drag right doesn't work?
Thanks!
it does not calculate correctly unless I type in the cell and F9 it.
Further, when I drag the formula right despite the next cell saying
=sum(E1:E5) it is returning the value of column D.
Any idea why the sum is not refreshing and why the drag right doesn't work?
Thanks!