In one worksheet I have checkboxes set up for a true/false value (if
checkboxes are checked then a violation has occurred) , when checked it sends
"true", when unchecked it sends "false" to column A in another worksheet that
corresponds to the violation in column B. In the same worksheet, if column A
has a true, it takes the corresponding violation in column B and will put
them in a cell. The formula reads all of those that are marked true. I
would like to take all of those that come up as true and put them in one
cell. Sometimes 1 box will be checked (1 violation) or it could be 15 boxes
checked (15 violations). If I ask for it to read the range of cells, I am
getting an error message if all cells aren't filled in with a violation.

What formula? What type of the error message? Please post your formula and
your expectation of the result.

"Riversage" wrote:

In one worksheet I have checkboxes set up for a true/false value (if
checkboxes are checked then a violation has occurred) , when checked it sends
"true", when unchecked it sends "false" to column A in another worksheet that
corresponds to the violation in column B. In the same worksheet, if column A
has a true, it takes the corresponding violation in column B and will put
them in a cell. The formula reads all of those that are marked true. I
would like to take all of those that come up as true and put them in one
cell. Sometimes 1 box will be checked (1 violation) or it could be 15 boxes
checked (15 violations). If I ask for it to read the range of cells, I am
getting an error message if all cells aren't filled in with a violation.