On Feb 20, 5:17 pm, wrote:
On Feb 20, 5:10 pm, "brownti via OfficeKB.com" <u31540@uwe 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 viahttp://www.officekb.com

assuming you are having your five values in a1:e1

enter in any cell in your sheet: =IF(COUNTIF(A1:E1;"")0;"Missing
Total";SUM(A1:E1))

hope, that's what you were looking for...

have a nice day

Michael (http://bereichverschieben.blogspot.com)

you might have to replace my semicolons by comma...sorry - german
keyboard