I need a formula that will give me the sum of a range that takes a letter and assigning it a number value - example tracking vacation time V=1, T=.5 I need a way to differentiate half and whole days by assigning a different letter?
Solved by Z. J. in 12 mins