I've got an excel worksheet that sums various cells from another worksheet. What I need is to sum these summed cells. I found that I can use the Value function, but only if I add a "+" between the cells (e.g. value(A1+A2+...)). Is there a way to get the value of a range of cells? (say A1 through A55?). I tried Value(A1:A55). this doesn't seem to work...
Login or Sign Up
- Log in with