=IF(AND(ISBLANK(A1),ISBLANK(A2),ISBLANK(A3),ISBLAN K(A4),ISBLANK(A5)),"Missing
total",SUM(A1:A5))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"brownti via OfficeKB.com" wrote:

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