Forum Discussion
excell issue
I have set up a column with each cell being filled with 1 or 0 depending on a condition.
This works and I have a column populated with 1 and 0 depending on the condition being realized or not.
I then have summed up all cells of the column to have a total.
The total is 0 despite the sum function being correct.
HELP !
yves
it is had without the actual sheet or even the specific formulas you use. One wild guess:
did you use something like
=IF( [condition], "1", "0")?
If so remove the "" around the numbers 1 and 0
3 Replies
If the "Condition" is a choice of two options.
="cell"="condition" ex. =A2="Text"
This will return true or false which will sum as 1 or 0.
Did you perhaps use formulas that return "0" and "1"? If so, those are text values - change them to 0 and 1.
Otherwise: Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
it is had without the actual sheet or even the specific formulas you use. One wild guess:
did you use something like
=IF( [condition], "1", "0")?
If so remove the "" around the numbers 1 and 0
