| T O P I C R E V I E W |
| Tukulti-Apil-Esarra |
Posted - 11/10/2017 : 11:00:16 AM
is it possible to treat the double dashes (--) or empty cells as zeros?
I have a column that sums up values in a few other columns. One of those columns have now stopped being filled with data. Because of this column now having empty cells or cells with --, the summation column does not calculate the sum. I can of course keep typing in zeros in this column but would prefer not to.
Example:
Col(A) | Col(B) | Col(C)=Col(A)+Col(B)
100 | 500 | 600
300 | 100 | 400
600 | 0 | 600
0 | 300 | 300
100 | 200 | 300
300 | -- | --
400 | -- | -- |
| 4 L A T E S T R E P L I E S (Newest First) |
| Tukulti-Apil-Esarra |
Posted - 11/15/2017 : 09:58:46 AM
Thanks. In column D I did Col(A)+Col(B)+col(C) for rows 1 to 100 with None Recalculate and then for the same column D did Col(A)+Col(B) for rows 101 to <auto> with Auto Recalculate. |
| nick_n |
Posted - 11/13/2017 : 5:57:23 PM
Hi,
Yes, of course. Select output column -> right click -> Set column values (or Ctrl+Q) -> put your formula (eg Col(A)+Col(B)+col(C)) -> select desired rows range (1 - 100) -> ok. And the same for rest of rows with another formula. BR,
Nikolay |
| Tukulti-Apil-Esarra |
Posted - 11/13/2017 : 4:54:37 PM
Can I somehow fix this using row indices? I'm summing three columns. Can I specify to sum all three from rows 1 to e.g. 100 and then from row 101 sum only two of the columns? |
| nick_n |
Posted - 11/10/2017 : 12:01:20 PM
Hi,
As a kind of workaround: Select column with "--" (col(B) in your case) -> "Ctrl+H" -> Find what "--" -> Replace with "0".
BR,
Nikolay |
