I think the formula was correct with the exception of the greater than
number. This should be it.

=IF(SUM(E18:E23)40,SUM(E18:E23)-40,0)

"Trevor Shuttleworth" wrote in message
...
Kerri

not sure I understand what you want but, maybe this:

=IF(SUM(E18:E23)0,SUM(E18:E23)-40,0)

Regards

Trevor


"Kerri Olsen" wrote in message
...
I need help writing a formula

if range E18:E23 is greater than 40, I want the number E18:E23-40 entered
into the cell, if false 0
--
Kerri