How do I enter formula that adds a range if less than a number or
 

I want to write formula that adds amounts in a range ofcells and if < a
number, enter sum, but if = than number, only add difference between sum and
number? I believe it to be an sumif function but can't seem to layout
formula.

How do I enter formula that adds a range if less than a number or
 

Confusing explanation! Can you reword it and include an example?

Biff

"Rose M" wrote in message
...
I want to write formula that adds amounts in a range ofcells and if < a
number, enter sum, but if = than number, only add difference between sum
and
number? I believe it to be an sumif function but can't seem to layout
formula.

How do I enter formula that adds a range if less than a number or
 

=SUMPRODUCT(--(A1:A1010),A1:A10-10)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rose M" wrote in message
...
I want to write formula that adds amounts in a range ofcells and if < a
number, enter sum, but if = than number, only add difference between sum
and
number? I believe it to be an sumif function but can't seem to layout
formula.