text has numerical values
I have a row of 15 cells. In some of these cells there is text. The text
has numerical values such as V=1, M=0.5, and H=0.25. There are usually
multiple combination of these text values and I would like to have a seperate
cell show the SUM total within a range. I tried COUNTA, but that returns a
whole number. I'd like to show a total where if I have V V M M H within a
range, using the values above, in my "total" cell I will have the end result
of 3.25. Any suggestions will be greatly appreciated
--
TXEagle in SAT
|