I am working on a spreadsheet and need some help with cause I can't seem to get it right. The column has 1 of 3 values. C for complete, P for Partially Complete, and N for Not Started. What I am trying to do is have a box at the bottom to tell me when cells 1 through 10 are maked C and when a cell is marked as C in cells 11 or 12 and a cell is marked as C in cell 13, 14, or 15. I am sure this can be done I just can't seem to get the formula right. I keep getting #VALUE for an answer.