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