I'm trying to add employee vacation days for the year. Vacation days taken are marked with a V in a cell and half vacation days are marked with 1/2V. Is there a way to add the vacation days so that V=1 and 1/2V=0.5 ?
I am currently using this formula to add the vacation days ("V") but cannot get it to add the half vacation days ("1/2V") as 0.5
=COUNTIF(D7:D372,"V")
Bookmarks