Count Multiple Values


I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to log employee sick days and count the total days for every month. They are marked using single letters (S for sick, P for personal, etc.) but sometimes, they are only half days and marked as S 1/2 or P 1/2. The count formula counts these all as 1, but I’m wondering if there is a way I can assign any cell containing 1/2 to be counted only as .5


By: GD

Leave a Reply

Your email address will not be published. Required fields are marked *