Hello,
i am making a spreadsheet for vacation at my work, and need a formular that kan add a value to a letter.
I want to make "H"=1, and "h"=0.5
So that when the letter is typed in a row, it will at last show how many days of vacation the person has taking.
if "H" is typed 4 times, and "h" is typed 4 times, it will at the ens say that the person has used 6 vacation days.
I have tried to use "=SUM(COUNTIF(D7:NE7,{"H","h"})*{1,0.5})
where D7:NE7 is the row that the letters should be typed in.
Although i maybe think that excel can't differentiate lower case and upper case. Do any of you know if it is possible to get excel to do that?
Best regards Nanna
Bookmarks