It shouldn't. Are those cells showing the value as numbers okay?

--
HTH

Bob Phillips

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

"katest" wrote in message
...
I am trying to add up a colomn that includes cells containing 'if'
formulas
but the total misses out the value in the the cells containing the
formula.
Can anyone help?