| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| IF statement | Excel Worksheet Functions | |||
| if statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
