give text a dollar numeric value
=SUM(INDEX(N1:N10,IF(ISNUMBER(MATCH(C1:C2,M1:M10,0 )),MATCH(C1:C2,M1:M10,0))))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Gav" wrote in message
...
How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I
want
the numeric value to be hidden so I am able to insert text codes into
cells
then sum a total at the end of a column and/or the bottom of a row that
displays a numeric total. I will have not more than ten text codes for
each
column.
|