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")
Maybe
=COUNTIF(D7:D372,"V") +(COUNTIF(D7:D372,"1/2V") /2)
Here's another one...
=SUM(COUNTIF(D7:D372,{"V","1/2V"})*{1,0.5})
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Maybe like this ...
=SUMPRODUCT((D7:D372="V")+(D7:D372="1/2V")/2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks