The STR function that is located in the attached file works great, except that when I leave the sheet that contains the function and come back again, the result is incorrect. I have to constantly "refresh" the function to keep the total correct. The problem is that this total is needed in other cells. Is this a STR function characteristic and can I fix this?
Bookmarks