If statement

  • Thread starter brownti via OfficeKB.com
  • Start date
B

brownti via OfficeKB.com

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?
 
D

Dave F

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

Dave
 
M

micha_delle

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?
Click to expand...

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)
 
Top