thanks. now is it possible to use this formula within another array function?
What I would like to do, is have this formula

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

as the 'true' value in an IF formula

as in
=SUM(IF((B1:B10=A2)*(E1:E10=B2)*(G1:G10A3), TRUE VALUE, FALSE VALUE))

thanks

"Gary''s Student" wrote:

=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)