Should read "... a 2-column list ... in A2:B4."

Aladin Akyurek wrote:
Create a-column list,

V,1
M,0.5
H,0.25

say, in A2:B2. Name A2:A4 SymList and B2:B4 ValueList.

Then invoke:

=SUMPRODUCT(SUMIF(SymList,E2:K2,ValueList))

where E2:K2 is a range of interest with cells housing instances of V, M,
and H (along with other items).

TXEagle wrote:

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

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.