formula help

[Bill H.]

I have a cell with this formula:

0"))}

I don't remember how it was made up (I got help on this forum), but now I
need to update it by changing the 316 summed value in the last expression to
681. When I do that, the starting and ending braces disappear, and the cell
containing this formula returns a #VALUE! message.

How to fix?

Thanks.

 

[Frank Kabel]

Hi
enter this formula with CTRL+SHIFT+ENTER (to create an array formula)

 

[Bill H.]

Say, that works GREAT!

Thanks.

Hi
enter this formula with CTRL+SHIFT+ENTER (to create an array formula)