=IF(COUNT(A1:E1)<5,"missing",SUM(A1:E1))

--
Don Guillett
SalesAid Software

"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6e183d2f3ea52@uwe...
I am trying to create an if statement that checks 5 different cells and if
they are empty, i want it to display "Missing total" if none of them are
empty i want it to sum them. How?

--
Message posted via http://www.officekb.com