Array formulas must be array entered (Ctrl-Shift-Enter). Alternately, you
can modify working array formulas with the menu-based search and replace.

Jerry

"Chris Valenti" wrote:

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!