| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM cells with blank value
I have a table where I need to Sumarize different columns.
Eg: =C9+E9+G9+I9+K9+M9+O9+Q9+S9+U9+W9 but in this row E9 and M9 have no data as all these cells have their own formula from other files like ='[2008-dosbocas-porcompr.xls]DosBocas (mat)'!G6, ecc. So, in this case these E9 and M9 have no values. The problem is that I am not able to use the first formula as I get a #value error. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Quantity Blank, Remaining cells in row appear Blank | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
Threaded Mode
