If statement

  • Thread starter Thread starter brownti via OfficeKB.com
  • Start date 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?
 
=IF(AND(ISBLANK(A1),ISBLANK(A2),ISBLANK(A3),ISBLANK(A4),ISBLANK(A5)),"Missing
total",SUM(A1:A5))

Dave
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling Dashes in IF statement 3
IF STATEMENT 6
Excel formula, sum the value cell and if empty cell left blank 0
Simple nested if and statement 2
check if any values on row 7
How to set cell value to emptry if three other columns are empty too 1
adding result of "if" statement.. 3
Problem with COUNTIF being off by 1 1

Back
Top