| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
To leave the cell Blank
Hello from Steved
If the cell has an 0 as a value what is required please to make it blank. =SUMPRODUCT(('Planned Kilometres'!$A$4:$A$109=1)*('Planned Kilometres'!$B$4:$B$109="P")*'Planned Kilometres'!$AC$4:$AF$109). Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leave cell blank | Excel Discussion (Misc queries) | |||
| blank cell turns to 0 | New Users to Excel | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Go to first blank cell | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
