sum function usin an IF statement

[Bob Phillips]

Bit short on detail, but maybe

=IF(rng>10,rng)

as an array formula, committed with Ctrl-Shift-Enter

or

=IF(rng1>some_val,rng2)

again an array formula, where rng1 and rng2 are the same size.

--

HTH

RP
(remove nothere from the email address if mailing direct)