Sounds like it. Could it be the numbers are formatted as text?

--
HTH

Bob Phillips

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

"Kerri Olsen" wrote in message
...
Thank you, it worked in another part of my work sheet, not where I want it
to, could be the formating of some of the data.

Thank you
--
Kerri


"Kerri Olsen" wrote:


--
Kerri


"Bob Phillips" wrote:

That is exactly what I gave you!

--
HTH

Bob Phillips

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

"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