Not sure what the problem is, but when I try to add (sum) two cells, it does not give any answer. So, I in cell E32, I am trying to get a sum of O32 and P32 and I get no answer. Also, if I copy the formula from E30 to E32, instead of giving me the sum of O32 and P32, I get the same output that I have in E30. Any suggestions?
It sounds as though calculation is set to manual or the cells are formatted as text.
If calculation is set to manual, you'll see "calculate" in the status bar at the bottom left.
If the cell is formatted as text, you'll see the formula, not the value.
Regards
Last edited by TMS; 10-19-2011 at 08:41 AM. Reason: typo
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Fantastic! Thanks. Actually there was a circular reference problem that I fixed and voila, it works now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks