I'd check your data. Maybe you've got text that looks like a number and
isn't getting added in. Maybe one that looks like 4.5 ? Could be a space
in there somewhere ?

Regards

Trevor


"Kerri Olsen" wrote in message
...
I am getting 0, when is should be 4.5
--
Kerri


"PCLIVE" wrote:

The formula provided should do that.
What are you getting?

"Kerri Olsen" wrote in message
...
I guess my question is not clear

if sum of E18:E23 is over 40, I want the difference entered in the
cell,
example total is 46 I want 6 in cell
if sum of E18:E23 is 40 or less, I want 0
--
Kerri


"Bob Phillips" wrote:

I think Trevor's should be

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

and here is an alternative

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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