| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif to return a blank if sum range is blank
You can keep your formula as it is (assuming it works correctly) and
apply a conditional format to the cell, such that if the value of the cell is zero then the foreground colour should be made white - this will then "appear" to be blank instead of showing zero. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I return a value in excel that looks at a range of number | Excel Worksheet Functions | |||
| Return a specified date when it falls within a range.... | Excel Discussion (Misc queries) | |||
| How to return a single value for a range of numbers | Excel Worksheet Functions | |||
| Vlookup return 0 when cell is blank | Excel Worksheet Functions | |||
| calculating return in a range | Excel Worksheet Functions | |||
Threaded Mode
