Hi Brandon,

To count a letter as a half using the COUNTIF function, you can use a nested IF function. Here's how you can do it:

1. Open your payroll workbook and select the cell where you want to display the total number of days used.
2. Type the following formula into the cell:
   Formula:

   =COUNTIF(A1:A10,"P")+IF(COUNTIF(A1:A10,"HP")0,0.5*COUNTIF(A1:A10,"HP"),0) 

3. In the formula, A1:A10 is the range of cells where you have recorded the personal days and half personal days used.
4. The first part of the formula, COUNTIF(A1:A10,"P"), counts the number of cells that contain the letter "P".
5. The second part of the formula, IF(COUNTIF(A1:A10,"HP")0,0.5*COUNTIF(A1:A10,"HP") ,0), checks if there are any cells that contain the letters "HP". If there are, it multiplies the count of "HP" cells by 0.5 to get the half days used, and adds it to the count of "P" cells. If there are no "HP" cells, it adds 0 to the count of "P" cells.
6. Press Enter to calculate the formula and display the total number of days used.