I am revising a spreadsheet I made years ago which includes this function:
=SUM(IF(Category="Misc",Hours,0)) . When I edit the function [for example,
change"Misc" to "Some"] I get this: #VALUE! I recalled that there is a
specific way to enter the change rather than simply hit ENTER.
Thanks!