Forum Discussion
Formula
I have a pretty easy question that I can not find the answer to. I want to create a spreadsheet where the names of the employees are on the left hand column the names of the offenses are on the top a...
Denise,
I think you are looking for =COUNTA(B2:C2). This will count the cells that are not empty in the range specified, (B2 to C2). If you paste this in D2, and then copy down, it should total each line. If you have more columns that need to be included, just be sure to change B2:C2 to include all of them.