I want to sum a list of cells that have condition formulas that return a
value (1, 2 or 0) based on data in other cells. Because the data in these
cells is not actually a number, it just shows a number - the sum function
doesn't work. Is there anyway around this?