I have a spreadsheet setup to monitor absence in the office. The columns are the days of the month 1 - 31 and rows are the month/employees

```
Mon Tue Wed Thu Fri
```

**January** 1 2 3 4
Jeanne

Jan

Ben

Ellie

Alice

Stef

Victoria

**February**

Jeanne

Jan

Ben

Ellie

Alice

Stef

Victoria

The absences are listed as AL, AL.5, SL & SL.5 = Annual Leave, Annual Leave Half Day, Sick Leave & Sick Leave Half Day

I want to be able to add a total column for annual leave and sick and create a formula that sums the total number of days and half days in each row.

I am having trouble make any formula recognise the AL.5 & SL.5 as a value of .5. I have tried adding a criteria table but I cannot get the formula to work.I am currently using excel 2013.