=SUM((((B1:B10)/C2)-1))

but it must be entered as an array function with CNTRL-SHFT-ENTER rather
than just ENTER.
--
Gary''s Student - gsnu200779


"smerk" wrote:

eg. that could complete a function such as

sum of (((B1:B10)/C2)-1)