Topic starter
I need to have a column that will have a "total" box, and be the sum of the figures above it. I do this when I'm updating my books, and it always works fine, but today in a different file, I'm doing = then clicking all the boxes that I want to be included in the total (with plusses in between), and I'm just getting "hashVALUE" after I've pressed return.
Anyone know what I'm doing wrong?
Posted : 04/06/2009 12:25 pm
Have you got some numbers formatted as text rather than numbers?
Posted : 04/06/2009 12:34 pm
as above - non-numbered format or text content in the column somwhere
Posted : 04/06/2009 12:38 pm
Can you post the function here?
Posted : 04/06/2009 12:45 pm
Topic starter
Yay! I had a pound sign. Now removed, and working.
Thanks guys, it's great on here! (mostly)
Posted : 04/06/2009 12:46 pm
Topic starter
monsta, not sure what that means.... but all fixed now, thank you 🙂
Posted : 04/06/2009 12:47 pm
