Hello to all.
My question is: how can i sum several cells which have values coming from an if formula.
Specifying, i have several cells, one for each day, containing an if formula to copy the value of another sheet/cell. The value is considered logical because is the result of the IF clause, but the value is not 0 or 1, it´s the value contained in the other cell.
My problem is that i want to sum all those cells and the result is always zero, meaning that excel is ignoring the cell's values.
If you click on the formulas icon the correct result appears but not on the cell itself.
Can anyone help me?
Thanks to all.
Tiago
Bookmarks