6 Replies Latest reply on Jun 24, 2014 1:30 AM by try67

    How do I count/add fields with numbers and fields with letters?

    JoshALogs

      This is an attendance calendar I'm making for my work.

      Cells in CLIENT A column will be marked with either a number ( >0, indicating how many hours attended) or a letter (A = absent, H = Holiday).

      I need 2 formulas/scripts I suppose:

       

      1) I would like cell DP1 to represent how many cells in the CLIENT A column are marked only with a number >0 -indicating how many days were attended, not how many total hours there are.

       

      2) I would like cell DA1 to represent how many cells in the CLIENT A column are marked only with the letter A -indicating how many days were not attended.

      at mil draft_Page_1.jpg