Hello, I've spent several hours trying to research this question on my own but to no avail. I have a range from c5 to ag5 and I need a formula which would look at each cell in that range and first identify the symbols (if present) in that range and then sum the value for each symbol. The symbols would be something like "8V", which I want to have a value of 8, "7.5V" would equal 7.5 and so forth all the way down to ".5V", etc. thus summing the total vacation hours for that range.
I've tried sumifs, sumproduct, vlookup formulas unsuccessfully. Any assistance would be appreciated.
example:
c5, d5, e5, f5, g5,
8V 4.5V 1V .5V Total from formula should give me 14
Bookmarks