sum function usin an IF statement
 

Bit short on detail, but maybe

=IF(rng10,rng)

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

or

=IF(rng1some_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)


"jimk" wrote in message
...