Forum Discussion

Denise Colon's avatar
Denise Colon
Copper Contributor
Oct 03, 2018

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 and then the I would be able to populate the columns with a DATE and then a number total would be calculated I don't think I am able to correctly articulate what I want but I need help! 

excel
Formulas and Functions

5 Replies

  • BobOrrell's avatar
    BobOrrell
    Iron Contributor
    Oct 03, 2018

    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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 03, 2018

    Hi Denise,

     

    Yes, that's not clear what you'd like to do. Perhaps you may generate manually small mockup file with what are your source data and which result you'd like to have - just only few records.

    • Denise Colon's avatar
      Denise Colon
      Copper Contributor
      Oct 03, 2018

      Basically if column A are names of people i want columns B & C to represent a point total such as 1 so if i put in a date on B2  such as 10/3/2018 when I  SUM B2 and C2 I would like to see a total of 1 in  D2